No, I'm sorry. I didn't mean upgrade to SQL Server 2008. I meant upgrade to the GDR. I don't think there's any cost associated there. The functionality improvements in the...

The GDR is for 2008, but it changes the tool pretty radically in terms of deployment. It works great with 2005. I'd go for it if I were you.

I just...

Yeah, I'd make sure you've got the SP for VS installed, but also, I'd strongly recommend getting the GDR version, which I think also has a service pack. It eliminates...

Without knowing what your query is doing and what your structure looks like, it's just not possible to answer this question.

If you can, please post the query, the actual execution...

Well, you can also see if a lock has an outstanding convert request inside sys.dm_tran_locks. That's an indication of lock escalation. Once the lock is escelated though, you won't see...

I'd use a server-side trace. If you're unsure how to put them together, you can use Profiler to build the scripts for you after you use the GUI to define...

I have to agree with Hans here. You may need to maintain logic in more than one location simply because you can't have a single solution for all problems. As...

You're going to have to implement a code solution, not try to control locking. Here's a rough outline of an approach. You add two columns, call them InUse and UserID...

WayneS (6/10/2009)

---

Hey gang,

A reader of my article today asked a very good question that I'm not sure what the answer would be. I'm hoping that someone along the likes of...

t_king (6/11/2009)

---

So if I have 3 tables with the following number of rows 7949, 837, 1848 and their respective logical reads in the query are 52, 58, and 144. So...

Based on the research and testing I've done with it, it's unlikely to cause much negative impact. It's also unlikely to cause much positive impact except in special circumstances. I'm...

YSLGuru (6/10/2009)

---

Thanks for the input but after spending a couple of hours (yet again) on Powershell, persuing the Microsoft PS specific sites & Googleing on PowerShell for sample code on...

RBarryYoung (6/10/2009)

---

Oh my, no. At StackOverflow the correct answer is to psychically determine what the OP meant and what their actual situation is and what their goals are. ...

How you can not be sure? Microsoft may be a large,...

A dump is just a backup. They're EXACTLY the same thing. Dump is just old terminology. I wouldn't do it for them. I get really, really, pissy when people demand...