Monitoring wait stats
This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.
The request was...
2016-02-23
171 reads
SQL In The Wild
Q&A from the DBA Fundamentals Virtual Chapter presentation
A couple weeks ago I presented to the DBA Fundamentals virtual chapter. The presentation was recorded and is available from...
2016-02-16
470 reads
Q&A from the DBA Fundamentals Virtual Chapter presentation
A couple weeks ago I presented to the DBA Fundamentals virtual chapter. The presentation was recorded and is available from...
2016-02-16
103 reads
and other pointless query rewrites
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-17 (first published: 2016-02-09)
1,925 reads
and other pointless query rewrites
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-09
149 reads
On the addition of useless where clauses
I remember a forum thread from a while back. The question was on how to get rid of the index...
2016-02-10 (first published: 2016-02-02)
2,413 reads
Does an index scan always read the entire index?
No.
That’s a bit short for a blog post, so let me explain. First, the difference between a seek and a...
2016-01-26
508 reads
Stop using Task Manager to check SQL’s memory usage!
There’s two fairly common questions I see on the forums around SQL Server’s memory usage. Either the question asks why...
2016-01-19
2,011 reads
Natively compiled user-defined functions
One new thing that SQL Server 2016 has added is the ability to natively compile user-defined functions. Previously, native compilation,...
2016-01-19 (first published: 2016-01-12)
4,187 reads
Book Review 2015
It’s been a few years since I wrote a review of books I’ve read, so this isn’t going to list...
2016-01-15 (first published: 2016-01-05)
1,719 reads
Blogs
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()
Comments posted to this topic are about the item Level 28: DAX Text Functions:...
Creating JSON I
Comments posted to this topic are about the item Creating JSON I
Expensive CPUs
Comments posted to this topic are about the item Expensive CPUs
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers