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:
Monday, March 18, 2019

Stay relevant and marketable

›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed...
Saturday, March 16, 2019

Use sys.configurations to find features that are enabled but perhaps not used

›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed,...