Are int joins faster than string joins?
This one comes up a lot on the forums, often as advice given…
“You should use integers for the key rather...
2011-02-15
5,478 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
Quest Webcast: Dos and Don’ts of Database corruption
I was guest presenter on last week’s Quest Pain of the Week presentation. The presentation is available for download from...
2011-02-14
647 reads
Is a clustered index best for range queries?
I see a lot of advice that talks about the clustered index been the best index for use for range...
2011-02-01
1,738 reads
Upcoming presentations
It’s looking like it’s going to be a busy year.
It’s only January and I already have three presentations lined up...
2011-01-28
544 reads
Distincting an IN subquery
This is going to be a quick one…
I keep seeing forum code (and production code) that includes the DISTINCT in...
2011-01-26
5,455 reads
Distincting an IN subquery
This is going to be a quick one…
I keep seeing forum code (and production code) that includes the DISTINCT in...
2011-01-18
6,131 reads
Capturing the Execution Plan
One last post on execution plans and Profiler (at least for now)
When trying to check a query’s execution plan, the...
2011-01-04
1,395 reads
Do IF statements cause recompiles?
I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...
2010-12-15
3,713 reads
Do IF statements cause recompiles?
I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...
2010-12-14
1,492 reads
Recompiles
I’ve looked at cache hit and miss events and at the cache insert and remove events. The only cache-monitoring event...
2010-11-18
2,161 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers