Very funny article! Actually, I like the term "Rooster Booster" better than "Bird Cannon." :hehe:

That reminds me of the Thanksgiving episode of "WKRP in Cincinnati" (an old 70's...

I like the phrase "High Velocity Pork Chop!" It is wonderfully obscure. 🙂 Although, I think I prefer the imagery of a "high velocity meatball." Somehow, I...

Now that you mention it, I do remember reading about temporary stored procedures. I wondered at the time (and I am wondering now) what possible use anyone could have...

You need to know what was going on before that transaction log backup. I've seen that happen when Index Reorganizations were done on some really large indexes. It...

Jeff Moden (12/21/2011)

---

Yep... me. I got tired of some real crap...

That was a well considered reply, G-Squared. The point you closed with (don't use this feature unless you know what you are doing) could be extended to virtually every...

GSquared (12/21/2011)

---

I've also had a few cases where dozens of stored procedures all needed the same three columns from the same two tables, and that kind of thing. Rather...

I'd like to post the view I just spent a week decomposing. It is several thousand lines long. However, I think my company might object, and I just...

bteraberry (12/19/2011)

---

Forbidding views doesn't really help anything in my opinion. Simply taking tools out of the toolbox doesn't prevent anyone from mishandling the tools that are still available. ...

SQLRNNR (12/19/2011)

---

Views can be very useful. One nice use is an indexed view. Also, using views to when you have to perform the same piece of code many...

The best way to do this is with the OVER clause. You should read through the documentation, here http://msdn.microsoft.com/en-us/library/ms189461(SQL.110).aspx.

Doh! :pinch: I think I should change my screen name to Homer Simpson! :sick:

Sorry, Craig! I posted the output from Sturner's query, not yours. Your query...

xp_ss_backup is an extended stored procedure for a third party product, SQL Safe by Idera. Download and install SQL Safe on your server if you wish to use it.

The...

Craig's solution looks perfect to me, but I think there may be a logical flaw in the question.

Here is the result set I got when testing Craig's query:

Order ID-Detail ID-Item...

Now this is one case where I have heard that Lock Pages in Memory can get you in trouble. If you have Virtual Servers with overcommit enabled on the...