Category Archives: SQL Server

DBCC CheckDB failed with error “DBCC could not obtain a lock on this object because the lock request timeout period was exceeded” Error: Today, My DBCC checkdb job failed with below error. Executed as user: USERNAME. Object ID 451805713 (object ‘dbo.AEETBL’): DBCC could not obtain a lock on this object because the lock request timeout … Continue reading →

Performance is always a most prioritized task for any DBA and every DBA always prefer to go for a proactive approach and keep your system’s performance on top rather than reactive when it comes to addressing user complaints. SQL Server is a complex system and due to the continuous increasing size of data and multiple … Continue reading →

CEIP (Customer Experience Improvement Program) is somethings runs from ages and almost each vendor perform it to collect product usage data, issues faced and other information. Vendor uses this information for market expansion, bug fixing and new features. But all this happen with user confirmation during or after installation. Microsoft is also doing it for … Continue reading →

Creating a System-Versioned Temporal Table – There are three ways to create a system-versioned temporal table with regards to how the history table is specified: 1) Creating a temporal table with an anonymous history table Creating a temporal table with an anonymous name. This is easiest way to create it when you do not concern … Continue reading →