This article isn't exactly what you want, but you can probably use it as a starting point

Are all the users using SSMS? This looks like an Intellisense query.

Well, still working on it. Added an index and that took 15% off.

The real winner is disabling and then re-enabling the FK's. There are 48 FK's on this...

SQLRNNR (8/24/2011)

---

Roy Ernest (8/24/2011)

---

LOL... The name Roy Ernest and nominated for pass board does not go together. 🙂

We will just do reviews on the applicants for board members. I...

Apparently the earthquake was felt in places here in NH, but I didn't feel it and no one I've talked to did and my sister-in-law was on a ladder painting...

ChrisM@Work (8/22/2011)

---

Hi folks, I've not visited here for ages, I hope you are all well.

Anybody recruiting presently? We've been recruiting a DBA and a TSQL developer (with some role...

Lynn,

Good luck on the 1st day back in SQL Server and conrgratulations!

I'm the friend Grant mentioned....

I'm not sure that that table and query hints would help much. The majority of the access patterns are seeks which I assume would be at most Page Locks....

Eric M Russell (8/19/2011)

---

Well, when creating a SQL Server Alert, the options currently include email, pager, SMS message, and Net Send. Tweets are typically for public broadcast. SMS messages are...

Jeff Moden (8/18/2011)

---

Gosh... I just thought of this... if all these things are properly FK'd (heh... if that doesn't sound like an HR violation, I don't know what does), then...

Jeff Moden (8/18/2011)

---

I don't normally recommend it but have you considered changing the FK's to "Cascade on Delete"? It sounds like that would be the easiest and fastest way...

Never used them. I think that they are a good idea, but I think that there is a need...

SQLRNNR (8/17/2011)

---

I am not entirely a fan of getting a cell-phone from work. Too often the implication is that you must be ready to work 24x7x365 if they provide...

Interesting editorial and certainly something we all need to consider. I honestly don't care that much about getting health care benefits from my employer anymore, which is good since...