Why is my pivot query not returning any data? How to debug a PIVOT query
If you have a PIVOT query and it isn’t returning the data you expect, what can you do to troubleshoot it? The thing to do is to break it...
2019-05-21
36 reads
T-SQL Tuesday #114 Puzzle Party – Roundup
Here’s my round-up for this month’s T-SQL Tuesday. Thanks to everyone who contributed last week. It was great reading your posts and seeing the different ways you interpreted the...
2019-05-21
107 reads
Do you have rarely used indexes that are hurting performance of writes?
We know that indexes are necessary for query performance but comes with overhead during DML operations. Usually, the overhead is worth the performance gain we get out of them....
2019-06-10 (first published: 2019-05-21)
868 reads
Working with SQLSaturday SpeedPASSes – revamped!
In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among other jobs that this entails, this also means that I am working with SQLSaturday SpeedPASSes....
2019-05-21
15 reads
Working with SQLSaturday SpeedPASSes – revamped!
In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among other jobs that this entails, this also means that I am working with SQLSaturday SpeedPASSes....
2019-05-21
19 reads
Working with SQLSaturday SpeedPASSes – revamped!
In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among other jobs that this entails, this also means that I am working with SQLSaturday SpeedPASSes....
2019-05-21
68 reads
What’s Unique About SQL Saturdays: Nearly Everyone Interacts with Other People
Today I was looped in on an email thread about the pros and cons of attending a specific event. One person on the thread asked if any of us...
2019-05-21
19 reads
Happy Hour at SQL in the City Austin
Tomorrow is SQL in the City 2019 – Austin. If you’ve registered, you’re going to want to come. From Kendra’s great opening keynote to Brian’s demo to a couple...
2019-05-21
15 reads
Containers: Getting an Image
I’m working with Docker running on Windows or Linux. There are other ways to do this, but Docker seems to be a pretty strong standard. I’ll leave it to...
2019-05-21
38 reads
Building Your Brand Right
I was interviewed yesterday by Stephen Wynkoop (twitter) for the upcoming SSWUG Virtual Conference on May 23rd. One of the questions was about how to keep management engaged on...
2019-06-07 (first published: 2019-05-21)
486 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers