Tip : Benefits of SCHEMABINDING in SQL Server
Monthly Archive: January 2017
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.