This is a DBCC command I learned from Brent Ozar’s Indexing video. To get statistics on an index, simply use:

Views –…

Read More

Find Last LSN Applied to Database

Here is the SQL to display the last LSN applied to the database (think log-shipping)

Views – 2703

Read More

Enabling and Disabling SQL Logins

Here is some simple T-SQL to enable or disable a SQL login account:

Views – 1708

Read More