The Right and Wrong of T-SQL DML TRIGGERs (SQL Spackle)

Triggers in T-SQL have many uses. There are right and wrong ways to write triggers. To learn the difference, read on...

Secondary XML Indexes

SQL Server Random Sorted Result Set

In this tip Dallas Snider illustrates how to write a T-SQL query that will return rows sorted randomly.

Foreign Key Fun

Remove data from tables

BREAK

XML Indexes

The Potential of Joins

An article about how we underestimate the power of joins and degrade our query performance by not using proper joins

Dynamically Query a 100 Million Row Table-Efficiently

This article describes methods of creating dynamic queries without the use of dynamic SQL to efficiently access large tables.

ColumnStore index