I would cap it too. Exact numbers are hard to come by because it's so dependent on the OS, what you're doing within SQL Server, etc., but I'd say, for...

I guess the thing to understand is what tempdb is used for. That'll help you and your developers understand whether or not it's a bottle neck.

Every temporary table, obviously,...

Some other thoughts, you're trying to find the average number of days but you're returning 146,000 rows. Do you really need that much data? Reducing the amount moved around can...

What you might be seeing is termed a regression by the optimizer team. They fight those tooth & nail, but sometimes they occur. Usually, but not always, you're doing something...

I might have misunderstood, but selectivity matters just as much in a clustered index. The same b-tree structure sits on top of the pages, controlling access and determining if you're...

I'll add one thing, Profiler is great, but don't run it directly against the production systems in the company. On those look up how to do a server-side trace.

It's not the size of the query or the plan that's the problem, it's the work table. Have you looked at the execution plan to determine why you're hitting a...

I suspect I'm confused. Normally you use schema's as a mechanism of managing access. If you move all the schema's to 'dbo' you're eliminating that security setting. Won't that be...

Hey! Nice talking to you as well.

OK. That clarifies it a bit. If you really want to measure selectivity, you add all the columns together. The leading edge, the first...

I'm a little surprised by the approach too. Was it SQL Saturday in NYC? Which presenter was it? I'm curious to see the presentation now.

You must test indexes suggested by the missing index process. It is absolutely not to be blindly trusted. I've seen it recommend an index on Column A and an Index...

Use sys.dm_exec_requests and see what is causing the procedure to wait. If it's blocked, trace the blocking chain, again, available from the same DMO.

GilaMonster (11/23/2010)

There are stories I could tell,...

With only a single row to send, I'd suggest just creating a procedure or parameterized query that lists the columns and send that over. That really is the better approach....

First question I'd ask is, what are those procedures doing. If it just runs and runs, something is up in that code. Rather than try to determine what's happening at...