Coming Soon SQL 2016 Live Query Statistics (LQS)
I recently stumbled onto a feature in the upcoming release of SQL Server 2016 that at first seemed really intriguing. Live Query Statistics – a way to see the query … Continue reading
June 2, 2015 · 1 Comment
TSQL Tue 65: Memory Optimized Hash Indexes
The topic this month is learn something new and then teach it to everyone else. Great topic Mike! Late last year I set the goal to finish up my MCSE. … Continue reading
April 14, 2015 · 2 Comments
Violating AdventureWorks Dating Policy with Merge, Hash, and Loop Joins
The logical joins (inner, outer, left, right etc) are familiar to any SQL pro. As the optimizer selects the physical join type that will actually perform the work however, this part of … Continue reading
October 13, 2014 · Leave a comment