Jeff Moden (8/15/2009)

---

Heh... please don't be. Your blogs are the epitome of what every DBA and database consultant...

When it's really down to the wire, I usually rely on the numbers from Profiler. I honestly don't know if that's right or not, but it's a leap of faith...

You do what I do, use the same number all the time. When I'm troubelshooting from a point of view, say SSMS, I do all the measures there. If you...

I'm pretty sure this one goes way back and may not be related to the table variables. I've run into it before. Do you think this is the issue?

And the Books Online can be accessed... wait for it.... online:

http://msdn.microsoft.com/en-us/library/ms130214.aspx

I agree with Matt. Need is a big word. I'd say they should be and are probably also the primary key & clustered.

Are those user defined functions multi-statement UDF's by any chance? I'd say that's where your problem is. Multi-statement UDF's don't have statistics. When you join them against data like this,...

Add another vote of confidence supporting you for doing well on your initial design. Now don't mess with it. There's nothing wrong with using lookup tables. As a matter of...

Excellent article, thanks Andy. It's also very well timed for my company. We're having some trouble convincing people that trunc & reload is NOT the industry best practice.

drew.allen (8/13/2009)

---

No, the...

Jeff Moden (8/13/2009)

---

Grant Fritchey (8/13/2009)

---

This is going to become a new badge of honor for people going for jobs or qualifying for MVP:

"And this article I wrote was plagiarized five...

Kit G (8/13/2009)

---

Does one even dare ask for a translation? Or...

drew.allen (8/13/2009)

---

If you are using joins to check, an inner join will only work where a record exists. If you want to check for non-existence, you will have to...

Pleasure!

I went to respond to your interpretation of the SSMS shorthand and decided that it would look too much like picking on the guy who did it....