Query Tuning 101: Debugging a procedure
I was recently asked to help tune a stored procedure that has been historically taking between 55 and 60 seconds...
2016-12-15 (first published: 2016-11-30)
4,382 reads
Daniel Janik
Nintendo NES Classic Edition giveaway! #SQLFamily
I’ve managed to get my hands on a Nintendo NES Classic and I’m going to give it away. The details...
2016-12-13
700 reads
Query tuning 101: How to measure Query Plan I/O cost
If you’re a DBA or a developer chances are you’ve looked at a query plan or two. While looking at...
2016-11-23 (first published: 2016-11-18)
3,164 reads
Query tuning 101: Problems with IN ()
If you’re a DBA or database developer, chances are you will have to write or rewrite queries from time to...
2016-11-14 (first published: 2016-11-10)
5,696 reads
Why Halloween slowed your queries
Let me start by saying that this isn’t your typical post about the Halloween problem. This is intended to describe...
2016-10-31
962 reads
Thank you to @MrDenny
I wanted to take a quick moment to thank Denny Cherry for selecting me for Speaker Idol this year.
For...
2016-10-29
761 reads
Read this before using SQL 2016 Temporal Tables
I’ve been testing the new Temporal Tables feature over the past day to see about using it in one of...
2016-10-26 (first published: 2016-10-17)
2,810 reads
Why I don’t love SELECT INTO
Long ago there were locking / blocking problems with the SELECT INTO statement. That’s not the case anymore and for AdHoc...
2016-10-20
1,045 reads
Making the case for CamelCase naming
Coding and database standards like a religion or politics. Some people are fanatics and others really don’t care whatsoever. Getting...
2016-10-17 (first published: 2016-10-10)
3,837 reads
An observation about Unicode in SQL Server Management Studio
A week or so ago I read a blog post and tweet about using an emoji in SQL Server. This...
2016-10-14 (first published: 2016-10-02)
2,177 reads
Blogs
Spark Connect Dotnet November 2024 Where are we?
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
A New Word: Ochisia
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
Create a Numbers Table in Power Query
This is a quick blog post, mainly so I have the code available if...
Forums
How Do You Patch 100 Database Servers?
Comments posted to this topic are about the item How Do You Patch 100...
Microsoft SQL announcements at PASS Data Community Summit 2024
Comments posted to this topic are about the item Microsoft SQL announcements at PASS...
How to Develop Custom T-SQL Code Snippets in Azure Data Studio
Comments posted to this topic are about the item How to Develop Custom T-SQL...
Question of the Day
What's the Ceiling?
What do I get as the results from this code?
SELECT CEILING (999.999), CEILING (-999.999);See possible answers