How does TOP WITH TIES work with ORDER BY? A simple example shows how WITH TIES returns the extra rows that match the value of the last row.
SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2
Comma Separated Values from a table column, part 2: SUBSTRING limits the XML length, so I rewrote the query with STUFF and FOR XML PATH to remove it.
XML exist: A Present Boolean Expression Still Exists
XML exist tests a nonempty XQuery result. Even false() returns a value, so use a node predicate to test presence and preserve NULL XML input.
SQL SERVER – Fillfactor, Index and In-depth Look at Effect on Performance
Where in SQL Server does 100 equal 0? In Fillfactor settings. An in-depth look at how the Fillfactor of an index affects page fill and performance.
SQL SERVER – Difference TempTable and Table Variable – Table Variable in Memory a Myth
Is a table variable in memory while a temp table lives in TempDB? It is a myth: both are created in TempDB, and a simple script proves it.
DATEADD Fractional Numbers: Truncate Before Addition
DATEADD fractional numbers are truncated, not rounded. Compare positive and negative day additions while preserving an explicitly typed date input.
SQL SERVER – ERROR: FIX: Cannot drop server because it is used as a Distributor in replication
Removing replication fails with Cannot drop server because it is used as a Distributor in replication? Two quick commands with sp_dropdistributor fix it.