One possible way to improve performance here is to create calculated columns and index them. This would negate the need to use functions on the join columns - which...

I am going to give my standard spiel here that you should find the budget to get a professional to come in for a few days to give your entire...

For those that do non-tsql development I wanted to point out a VERY important tidbit in Linchi's article mentioned above:

"If the stored procedure is called as a language event (i.e....

Yes, there is. Buy a copy of ApexSQL Log from ApexSQL.com. It is my VERY strong opinion that every production sql server environment should have the functionality this...

I have been advising my clients to go to 3186 and stop there for now. I got some validation for that last night on the SQL MVP monthly topics...

Actually AFAIK it is STILL the best practice to reference columns as you state - at least in ADOc. There is a demonstrable gain in efficiency in doing so.

The particular issue I was speaking to would take just the opposite kind of testing to nail down. Think 1M iterations of a select from a single tinyint table...

Jeff, your description is right out of my latest client's playbook!! They have spent the last 2+ years throwing mid 7 figures at hardware to address flagging performance (and...

Jeff Moden (1/16/2008)

---

I consider myself to be one of the best around at sql server perf tuning and this product will take me to the next level due to some...

Better than agreeing to disagree Colin is to KNOW. Review this page, which has very clear and concise examples of why you really do need to read ALL other...

Hmm, I wonder about that. I would think that the optimizer would 'flesh out' the full column list for SELECT * queries at the time the plan was created,...

ApexSQL Edit is absolutely incredible for the array of things it can do to assist you in writing, testing, controlling, outputting tsql and sql server data. I am also...

Independent consulting can be the best thing in the world - or it can be a total nightmare. You could make $200K one year without breaking a sweat and...

Defragging tiny tables is a waste of time and effort. I usually set defrag scripts to ignore tables with less than somewhere between 50 and 500 pages, depending on...

icata (1/14/2008)

---

...The benchmark should be fairly close to my situation since the memory allocation for the procedure cache is similar in 2000 and 2005, as you guys pointed out. ......