Finding unused indexes requires a measured window, SQL Server usage counters, and a safe removal test before an index earns a drop decision.
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
A short T-SQL script to set server level FILLFACTOR, plus the Books Online definition of FILLFACTOR and what its values from 0 to 100 mean.
Multiset Difference: Remove Only Matching Duplicate Occurrences
Multiset difference removes matching occurrences while keeping any extra copies from the left input. I assign occurrence numbers before pairing rows. A value’s presence on the right should not automatically remove every left copy.
SQL SERVER – 2005 – Connection Property of SQL Server Management Studio SSMS
How to change connection properties in SSMS as you connect, like using named pipes instead of TCP/IP, as I do for one of our servers. Screenshots show each step.
Why You Should Name Default Constraints
Name default constraints so deployments can find them reliably, and replace system-generated names through a reviewed migration.