Also, if you don't want to open a new query window, but just switch the connection in the one you're on, you can click the icon that's in the...

To capture individual statements, or batch calls, you can use a server-side trace. These are set up through the Profiler utility that comes with SQL Server. The specific event you're...

I love it. They're running a delete statement with a READ_UNCOMMITTED isolation level... like that'll prevent locking.

You need to get on the vendor about the issue. It's pretty clear...

mike.renwick-894639 (5/7/2010)

---

Thanks for +ve comments,

Anyone interested in sample code of what we did, take a look here

http://www.mediafire.com/?eim2mydnjti

Disclaimered as you'd expect.

Regarding the ongoing debate about "proper" source control usage, I think...

tony.turner (5/7/2010)

---

eric_russell 13013 (5/6/2010)

---

Note that because it gets this info from database management views, the history only goes back to the last time the SQL Server service was last started....

Unfortunately I don't have any funny names for code.

I do have two quasi-funny phrases that are used around here, a lot, too much.

The first, is a joke, say it, everyone...

Everyone turning off parallelism is ignoring the fact that some queries can benefit. I strongly recommend you explore increasing the cost threshold of parallelism before you simply switch it off....

Yep. They told me that leaving parallelism turned on (0 or some number greater than 1) and adjusting the cost threshold up is the way to go. I was told...

Frequently, but not always, it's not that the system can't benefit from parallelism, it's that the threshold for parallelism is set to low. The default, 5 I believe, is way...

I'm with Steve. The only way I know to make transactions smaller is to... make the transactions smaller. Break apart the data in some fashion so that you're moving it...

Steve Jones - Editor (5/6/2010)

---

GilaMonster (5/6/2010)

---

Grant Fritchey (5/6/2010)

---

Hmmm... They never even asked me how many questions I answered. I think if you took away the number of times I said...

tymberwyld (5/6/2010)

---

I'm really surprised that no one has mentioned using "Database Projects" in Visual Studio (2003 - 2008). Unfortunately, Microsoft has removed this Project Template with VS 2010+ but...

GilaMonster (5/6/2010)

---

Steve Jones - Editor (5/6/2010)

---

Not a bad thing, but for those of you that are MVPs, keep that in mind when reporting. I tend to report about 3/4 of...

Steve Jones - Editor (5/6/2010)

---

Not a bad thing, but for those of you that are MVPs, keep that in mind when reporting. I tend to report about 3/4 of my...

Steve Jones - Editor (5/6/2010)

---

Top Ten Posters in this thread (out of 15,100 or so)

Lynn Pettis 1533

CirquedeSQLeil ...