sknox (2/28/2011)

---

mtassin (2/28/2011)

---

I got this right but...

SELECT 0%0

gives

Msg 8134, Level 16, State 1, Line 1

Divide by zero error encountered.

So it seems you can use it to divide 0 by 0...

Top notch question! As I've mentioned earlier, I like these hardware related questions - not that I'm a hardware expert. I'll have to learn more about this. ...

My previous avatar was of a Siberian Husky - love those dogs and currently have one.

I liked the movie Up!, and I'm not exactly a spring chicken 'round...

Excellent point about setting up a staging server and the disaster recovery process. Go Steve!

I've tried to resist learning how to cook many desserts, but I had to try this one! It's actually Emeril's recipe for Lemon Icebox pie. (No garlic, but...

Mmmm, I see lots of garlic in a most of these recipes! 'Gotta be good! Garlic's fantasitc.

I have to deal with this kind of thing at times. You can also put a case statement into your ORDER BY clause such that the order is modified....

I really liked this question. (Hey, I got one right! :-P)

Overall, I like all your questions Steve. Yes, more like this.

paul.knibbs (2/2/2011)

---

ReadyBoost is more of a replacement for insufficient RAM than anything...if you have plenty of RAM you won't see much benefit from using it. Oh, and you need a...

Which makes me happy that I went with AMD this time! :w00t:

By...

I was a foxpro programmer for a long time. I think It was a good RDBMS. But it did have its issues. At a FoxPro conference I...

GilaMonster (1/31/2011)

---

Do you understand how SQL uses the buffer pool for data cache? Need to see where to start explanation from.

Being in the buffer pool and being on disk are...

GilaMonster (1/31/2011)

---

mtillman-921105 (1/31/2011)

---

Apparently, SQL will use memory instead when it can. If so, that's an intelligent design since of course writing to disk is slower than using memory. ...

According...

Here is a short blog post showing the differences:

http://www.sqlservercurry.com/2010/03/temporary-tables-vs-table-variables.html

Table variables can be written to the temp db, but they can also perform better with small data sets.

p.s., I don't...