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...

Just add an alias:

SELECT MAX( RowNumber ) FROM

(

SELECT

ROW_NUMBER() OVER (ORDER BY MSG_DTM_LASTSTATUSTIME DESC) as RowNumber

FROM

Message_MSG msg with(nolock)

) AS x

Can you use PowerShell instead? If so, I've got a good script I can point you to.

First thing I'd do is get the data model. Do you have a data modelling tool like ERStudio or ER/Win? If not, you'll have to use the built in model...

Thanks for the article Sarvesh. You may want to spend a little more time on the next one, just nail down why these things occur. As you showed, it's not...