SQL Server Code,Tips and Tricks, Performance Tuning
A blog about SQL Server, Books, Movies and life in general
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,...
Monday, February 18, 2019
Calculating Sexy Primes, Prime Triplets and Sexy Prime Triplets in SQL Server
›
The other day I was reading something on Hackernews and someone posted a link to a Sexy Primes wikipedia article. I looked at that and th...
1 comment:
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...
‹
›
Home
View web version
