Which Columns Are Looked Up?
A common issue in performance is the lookup, key or RID, but the question frequently asked is, which columns are looked up? You need to know in order to...
2022-02-07 (first published: 2022-01-24)
453 reads
The Scary DBA
Two Clustered Indexes?
Everyone knows that you only get a single clustered index, right? Wouldn’t it be great though if you could have two clustered indexes? Well, you can. Sort of. Let’s...
2022-01-31 (first published: 2022-01-18)
456 reads
Why Is “WHERE 1=0” Slow?
I saw a question the other day, questioning why they’re creation of temporary tables was so slow. What they were doing was (a much more complicated version of) this:...
2022-01-24 (first published: 2022-01-10)
919 reads
Identifying Recompile Causes
Strictly speaking, a recompile isn’t really a performance tuning problem. In fact, a lot of time, recompiles are desired because they reflect changes in statistics which are likely to...
2022-01-12 (first published: 2022-01-03)
293 reads
Get SQL Server 2022 Now: It’s Called Azure
If you’re like me, your palms went into a cold sweat to get your grubby fingers on the bits for SQL Server 2022 a few nanoseconds after you heard...
2021-11-29
74 reads
PASS Data Community Summit 2021: I’m Excited!
I sincerely hope this isn’t the first time you’re hearing about the Pass Data Community Summit that’s coming up in just a few weeks on November 8-12, 2021. But,...
2021-10-15 (first published: 2021-10-04)
253 reads
PASS Data Community Summit 2021: I’m Excited!
I sincerely hope this isn’t the first time you’re hearing about the Pass Data Community Summit that’s coming up in just a few weeks on November 8-12, 2021. But,...
2021-10-04
23 reads
Login Timeouts
I was recently approached at work about a company that was seeing tons of timeouts in SQL Server. I was asked how to troubleshoot this. There are lots of...
2021-10-06 (first published: 2021-09-27)
591 reads
Login Timeouts
I was recently approached at work about a company that was seeing tons of timeouts in SQL Server. I was asked how to troubleshoot this. There are lots of...
2021-09-27
12 reads
Containers: A Short Rant
I find myself doing more and more work with containers. Yet, I also find that a lot of people seem to be resistant to the concept. I’m always surprised...
2021-09-29 (first published: 2021-09-20)
491 reads
Blogs
Installing and Configuring containerd as a Kubernetes Container Runtime
This post shows you how to install containerd as the container runtime for Kubernetes...
It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
Car Update October 2026
By Steve Jones
This month I want to look at a few of the things I’ve seen...
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers