Friday, May 22, 2020

PostgreSQL adds FETCH FIRST WITH TIES.. just like TOP n WITH TIES in SQL Server

›
PostgreSQL 13 Beta 1 was released yesterday, you can read the release notes here https://www.postgresql.org/about/news/2040/ One thing t...
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, 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...