SQL Server 2008 adds separate DATE and TIME datatypes, something DBAs wanted for years. I compare them with the SQL Server 2005 way of using DATETIME.
SQL SERVER – Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script
Index Rebuild drops and recreates the index, while Index Reorganize reorders the leaf nodes. Rebuild above 40% fragmentation, reorganize between 10% and 40%.
SQL SERVER – Enabling Clustered and Non-Clustered Indexes – Interesting Fact
When enabling clustered and non-clustered indexes, order matters: enabling the clustered index does not enable the others, but rebuilding all indexes does.
SQL SERVER – DISTINCT Keyword Usage and Common Discussion
Can you apply the DISTINCT keyword to only one column in a SELECT? No, it always applies to all the columns. I explain why and get the same result with GROUP BY.
SQL SERVER – Get Information of Index of Tables and Indexed Columns
sp_helpindex is a handy stored procedure that shows every index on a table, its description and the indexed columns. One line of T-SQL does it.
SQL SERVER – T-SQL Script to Find Details About TempDB Information
An old but reliable T-SQL script I use to check TempDB Information: file names, size in MB, autogrowth status and the growth setting of each file.
SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use.
Error 3702 says you cannot drop database because it is in use. Switch to master, find other connections and drop it safely with this fix.