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
3,149 reads
This one comes up a lot on the forums, often as advice given…
“You should use integers for the key rather...
2011-02-15
3,149 reads
I was guest presenter on last week’s Quest Pain of the Week presentation. The presentation is available for download from...
2011-02-14
635 reads
I see a lot of advice that talks about the clustered index been the best index for use for range...
2011-02-01
1,328 reads
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
534 reads
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
This is going to be a quick one…
I keep seeing forum code (and production code) that includes the DISTINCT in...
2011-01-18
5,558 reads
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,324 reads
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
I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...
2010-12-14
1,482 reads
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,074 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Sample data: jan 10gb feb 15gb mar 16gb april 14gb(truncate data) may 18gb june...
Everybody (well almost) knows that if you want to learn the design patterns for...
How many table hints can I include in a query?
See possible answers