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.
Right-Sizing SQL Server: Reading CPU and Memory Use Before Consolidation
Base right-sizing SQL Server on sampled CPU, memory pressure, buffer use and interval I/O, then compare peaks across a full business cycle.
In-Memory OLTP Migration Checklist in SSMS: Step by Step
The In-Memory OLTP migration checklist shows which tables and stored procedures can move to memory-optimized objects. This post sizes up the tables with T-SQL, walks through the wizard in Management Studio and explains how to read the reports.
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.