You might have noticed an error in the application log for some server with in your environment which says sysdatabases in SQL server instance <Instance Name> is empty. Cause   This is a…

This table is the datastore for all the messages in sql server system.The severity of the message is also included.I was curious to understand messages are generated in what all…

I have been working on various configure options which sql will allow its users to do and they are really interesting. Note : Changing these options should be done only…

Recently I observed an issue where we were trying to shrink a database file [Shrinking is not recommended in Production environment as it will cause fragmentation] and SQL Server was…

Lets discuss this in a better and interesting way : Business Manager  – Login ‘guyxyz’ is causing lot of issues and we need to know who created this login without…

Trace flags are real helpful when it is used for a specific requirement. Trace flag can set a specific server characteristic or turn off a behavior. We have Global and Session level…

Need to quickly find OS info?  Just run ‘msinfo32’ and it will pull you all the info you need just in few seconds. I normally run this to check if…

Today I was going through a user question in one of the blog and it was related to ‘Max user connections to SQL Server’ If you run ‘ Select @@MAX_CONNECTIONS ‘  you will get…

Recently was observing log file growth for tempdb and noticed that SQL Server Engine will apply a CHECKPOINT automatically when the log file size reach a threshold of 70%  (When autogrowth is disabled…

” Windows Server R2 is a revolutionary change and SQL 2008 R2 is a evolutionary change”