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,077 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
636 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,629 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
535 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,009 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,379 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,484 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,125 reads
Blogs
Monday Monitor Tips: The Jobs Report
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
Automating SQL Maintenance: How DevOps Principles Reduce Downtime
By Chris Yates
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To...
Forums
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers