Saturday, May 17, 2025

Benefits of Indexes

›
This is day fifteen of the  SQL Advent 2012 series  of blog posts. Today we are going to look at the benefit of indexes So how does an in...
Monday, August 02, 2021

How to connect to a SQL Server instance on a different domain and a non default port number?

›
  We have several domains at my job, we have a dev domain, a prod domain and then several other domains. Recently we had some domain changes...
1 comment:
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:
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...