SQL Server expert Dominic Wirth shares a script that gives a utilization overview of the local AlwaysOn replica server: database count and size, by role and group.
SQL SERVER – Rebuild Index Job Failed – Error: 9002 – The Transaction Log for Database ‘PinalDB’ is Full Due to ‘LOG_BACKUP’
A rebuild index job kept failing with error 9002: The transaction log for database ‘PinalDB’ is full due to ‘LOG_BACKUP’. Here is how I found the real cause.
Which is Optimal – TOP 0 OR WHERE 1 = 2? – Interview Question of the Week #190
Which is optimal, TOP 0 or WHERE 1 = 2? Many interview answers get this wrong, but they are both the same, and STATISTICS IO shows why.
SQL SERVER – SSMS – Enable Line Numbers in SQL Server Management Studio
When I guide a DBA over a screen share, line numbers make it easy to point at the right spot. Here is how to enable line numbers in SSMS.
Wide Covering Indexes: The Cost of INCLUDE Everything
Adding every column with INCLUDE feels like a free speed-up. Here is a small demo of the space, reads and writes you pay for.
Alphabets – SQL SERVER – Retrieving Rows With All Alphabets From Alphanumeric Data
I got an email from one of my blog readers asking for an easy way to identify if a given string contains only alphabets. There can be methods.
SQL SERVER – Applying NOLOCK to Every Single Table in Select Statement – SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
READ UNCOMMITTED changes session read isolation without adding NOLOCK to every table. A workshop procedure made the distinction useful.