Here are few of the best practices one should follow for SQL Server Health Check.
SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Database Dilbert
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.