How long since the last execution did you query the dmv's? If it's hours or minutes, you may have a serious memory issue. If it's days or weeks... not at...

Just hit the microsoft documentation. There's tons of information available there.

The error is very straight forward. You've got duplicate data. The key is to identify what constraints you have and then break down the procedure and capture the data output...

To eliminate the key lookups you need to make the non-clustered indexes into covering indexes by either adding columns needed to the key or as included columns. But you need...

Only use nvarchar if you are absolutely going to be using the extended character sets. If you're just using some of the ascii characters with umlauts or whatever, you just...

One word. Cursors.

I'm 46 and I think I'm going to try being a geek forever. I'm just not the management type and I really like playing with toys. I know an MS...

Whoa! I didn't notice that guy had 1200 posts. What the heck is up with that? You take that much time and you still don't get silly fundamentals? And I'm...

What about good?

What about evil?

What about right?

What about wrong?

Is there a Vorlon in the building?

Profiler would be my first choice.

Second wouldn't be sp_who2. It'd be sys.dm_exec_requests. With that you can link to other dmv's to get query text, execution plans... whatever you need. But,...

To heck with google. Open up Books Online. A lot of, most, of the information you need is in there. You don't need to go googling until or unless you...

Nice job Sylvia,

When you kick up this much mud, you did well.

I do need to disagree with you though. Picking and choosing when to alias or when not to leads...

RBarryYoung (5/6/2009)

Grant Fritchey (5/6/2009)

I don't know. I met Barry at the PASS Summit last year. He sounded a bit like Darth... an avuncular friendly...

I don't know. I met Barry at the PASS Summit last year. He sounded a bit like Darth... an avuncular friendly Darth, but Darth...

Can you run a query against sys.dm_tran_locks? That will give better information. Specifically we need to see the entity_id, the object getting locked.