SQL

Frequent recompilation of execution plans Inaccurate statistics Excessive use or improper configuration of tempdb Excessive blocking a...

You can get below error if you have ‘DOT’ in between your constraint name. SP_rename fails because object_id(ContraintnamewithDOT) returns ...

Here is a useful script to get the unused index in a Database. This may be inaccurate sometime. So you had to apply commonsense before runn...

I got this error in my event log ID 10016 of my database server installed with Windows Server 2012, in which i have only installed SQL ser...

Intellisense is a new feature that comes with SSMS(SQL Server Management Studio) 2008 onwards. Intellisense makes coding quite easy.  Some...