Tip : Benefits of SCHEMABINDING in SQL Server

Tip : More on Recovering Access to a SQL Server Instance

I show that DISTINCT and GROUP BY are usually interchangeable, but there are cases where one performs better than the other.

For T-SQL Tuesday #86, I highlight a few of my favorite bugs and feature requests on Connect (RIP).

I start digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.