This is my favorite Dilbert. Dilbert is an American comic strip written and illustrated by Scott Adams, first published in the year 1969.
SQL SERVER – DBCC CHECKDB Introduction and Explanation – DBCC CHECKDB Errors Solution
DBCC CHECKDB checks the logical and physical integrity of all the objects in the specified database. If DBCC CHECKDB ran on database user should not run DBCC CHECKALLOC, DBCC CHECKTABLE, and DBCC CHECKCATALOG on database as DBCC CHECKDB includes all the three command. Usage of these included DBCC commands is listed below.
SQL SERVER – Importance of Master Database for SQL Server Startup
I have received following questions. I will list all the questions here and answer them together.
What is the purpose of Master database?
SQL SERVER – Simple Example of WHILE Loop With CONTINUE and BREAK Keywords
I have tried to explain the usage of simple WHILE loop in the first example. BREAK keywords will exit the stop the while loop and control is moved.
SQL SERVER – Set Server Level FILLFACTOR Using T-SQL Script
As the title is very clear what this post is about I will not write long description. I have listed definition of FILLFACTOR from BOL here.
SQL SERVER – 2005 – Connection Property of SQL Server Management Studio SSMS
Following images quickly explain how to connect to SQL Server with different connection property. It can be useful when connection properties need to be changed for SQL Server when connected. I use this in my company when I connect to one of our servers using named pipes instead of TCP/IP. Let us learn about Connection Property of SQL Server Management Studio SSMS.
SQL SERVER – 2005 – Different Types of Cache Objects
About two months ago I reviewed book SQL Server 2005 Practical Troubleshooting: The Database Engine. Yesterday I received a request from reader, if I can write something from this book, which is not common knowledge in DBA community. I really like the idea, however I must respect the Authors copyright about this book. This book is unorthodox SQL book, it talks about things which can get you to fix your problem faster, if problem is discussed in book. There are few places it teaches behind the scene SQL stories.