How to find unused INCLUDE columns in nonclustered indexes for SQL Server.
[...Read More]
There are performance implications when choosing between the Default Schema and an Explicit Schema for SQL Server's OPENJSON rowset function.
[...Read More]
Can the performance of PIVOT be beaten with newer T-SQL features?
[...Read More]
Return the first value in an ordered set of values with analytic function FIRST_VALUE.
[...Read More]
Why I'm not as gung-ho about Microsoft certifications as I used to be.
[...Read More]
How to add a custom Transact-SQL code snippet to SQL Server Management Studio.
[...Read More]
Run both analytics and OLTP workloads on the same database tables at the same time.
[...Read More]
Acquire web page data in-database with Machine Learning Services...and JSON.
[...Read More]