Showing posts with label Howto. Show all posts
Showing posts with label Howto. Show all posts
Monday, March 15, 2021

After 20+ years in IT .. I finally discovered this useful command

›
Very similar to my  After 20+ years in IT .. I finally discovered this... post, I discovered yet another command I should have know about O...
1 comment:
Wednesday, May 06, 2020

You know about waitfor delay but did you know there is a waitfor time?

›
I was looking at some code I wrote the other day and noticed the WAITFOR command.. This got me thinking. How many times have I used WAITFOR...
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...
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 ...
Thursday, February 14, 2019

Finding rows where the column starts or ends with a 'bad' character

›
A coworker came to me asking me for some help. He had some issues trying to convert some data from a staging table to numeric. I asked him t...