Profiler is usually the way to go on this kind of thing.

If what you're doing is some sort of audit data and it will need to run indefinitely, then adding...

I agree with Jack.

The first question is: Are you the only person currently adding data to these tables?

If so, my second question is: Can you find a range of viable PK values, include...

If there are indexes other than the primary key on any of the tables, you might try disabling those indexes before the delete and then rebuilding them afterwards. Books...

You can do this:

Order By

Case

When Priority = 'High' then 0

When Priority = 'Medium' then 1

When Priority = 'Low' then 2

End

That should get you what you need. Might be...

Another current discussion that might have what you need is:

http://www.sqlservercentral.com/Forums/Topic474876-361-1.aspx

Is that what you're looking for?

Clever. I like it. This'll come in useful to me on the project I'm doing next week. Thanks.

john g (3/27/2008)

---

Pet Peeve on...

Would it be difficult for MS to give the option whether or not to allow other windows to grab context from the current one?

Back in the...

Yeah, the audit features in '08 look pretty useful.

rbarryyoung (3/26/2008)

---

Actually, I find that including CreateDate, CreatedBy, UpdateDate and UpdateBy columns on the table give me the most bang for the buck by far. More than enough information...

You're welcome.

I'd go with a proc for the final select, instead of a view. Then you can use input parameters. But basically, yeah, that should do it.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Has the feature comparisons for the various editions of SQL 2005.

Yes. (Here I am, with their logo staring me in the face as I type these things, and I still managed to...

Shaun McGuile (3/26/2008)

---

Seriously? 'People' (Citizens of the USA and other countries) don't reboot their PC's on a daily basis!

This is Windows! (Kick the unlucky person into the big pit!) It's...

Matt Miller (3/26/2008)

---

richardd (3/26/2008)

---

Thankfully, this has been fixed in Vista - the reminder message is now a balloon-tip from the system tray.

If you have 2000 SP3 or XP SP1 or...