Well thought-out and illustrated Jason, thanks! 😎

So should we always check queries returning just a few rows to see if a forced Nested Loop would help?

Excellent Wayne, thank you sir!

:smooooth:

paul.knibbs (12/28/2010)Tom's Hardware actually did a review where they assessed how much of an impact anti-virus had on game performance. The answer was, pretty much none:

http://www.tomshardware.com/reviews/anti-virus-virus-scanner-performance,2777.html

And it's not like it's...

At least you made him sweat it Lynn - good going. 😎

GoBolts has twenty projected points up on...

If DeSean Jackson (Probable) plays tonight, watch out PPP! :w00t: SQL Bolts is within striking distance and this week's game gets all settled tonight.

GO SQL Bolts GO! ...

Will1922 (12/28/2010)

---

Hmm. Turn off their antivirus for better game performance? Seems like a no-brainer for me. Not just better performance on Steam, but any game would...

My new PC is amazing.

The lowest Windows Performance Index is 7.3. Oddly enough, the 7.3 is for the hard drive, and it has a 120GB SSD. ...

That's great - thanks!

Sometimes I wish that t-sql had an...

No worries, if you're not used to the syntax, then nothing's easy about it. 🙂

I think a CASE statement would work here rather than using an IF. (IF won't work within a SELECT.)

SELECT CASE WHEN DESCRIPTION= 'Stop save' THEN 'gddo' ELSE 'turr' END...

PowerPivotPro (12/20/2010)

---

I was stricken with a nasty stomach virus all day yesterday, sleeping on and off, only catching rare soundbites of NFL that the tv offered me. It was...

I've enjoyed using Red Gate's free Search ad-in tool for questions like that. You can get it here:

http://www.red-gate.com/products/sql-development/sql-search/

Well, time for my Husky to wimper off, stage left... :crying:

But Go SQL Bolts with your 142 points. If I read the chart right, you are who's taking...

SanDroid (12/16/2010)

---

mtillman-921105 (12/16/2010)

---

But I think the trouble comes in when you're creating different tables with the same name in different nested procedures. When you execute Select * from #test1,...