Monday, January 20, 2020

TVPs vs Memory Optimized TVPs

›
The other day I was thinking about the blog post Faster temp table and table variable by using memory optimization  I read a while back. Si...
Monday, December 30, 2019

Top 10 posts from the last decade

›
As we finish the tumultuous 2010s and are ready for the roaring 2020s, I decided to take a quick look at the ten most viewed posts from th...
Wednesday, October 30, 2019

SQLSTATE 4200 Error 666 and what to do.

›
This morning I was greeted by the following message from a job email The maximum system-generated unique value for a duplicate group wa...
2 comments:
Tuesday, June 11, 2019

Can adding an index make a non SARGable query SARGable?

›
This question came up the other day from a co-worker, he said he couldn't change a query but was there a way of making the same query p...
1 comment:
Wednesday, April 24, 2019

How to count NULLS without using IS NULL in a WHERE clause

›
This came up the other day, someone wanted to know the percentage of NULL values in a column Then I said "I bet you I can run that ...
Sunday, April 14, 2019

How to check if an Extended Event session exists before dropping it

›
Are you still running profiler or have you transferred to using Extended Events? I use Extended Events almost exclusively now because it...
Saturday, April 13, 2019

How to improve your tech skills

›
Today we are going to look at how to improve your tech skills. This really is a continuation of the  Stay relevant and marketable  post fro...
Wednesday, March 20, 2019

Some numbers that you will know by heart if you have been working with SQL Server for a while

›
This is just a quick and fun post. I was troubleshooting a deadlock the other day and it got me thinking.... I know the number 1205 by h...
5 comments: