Jet was always more like a turbo-prop anyway. Thanks for the question.

Decent sized monitor (raised up about 4 inches! a stack of old paper works), comfortable chair (although a standing desk does sound interesting), Paint, Outlook/Office that's a version less that...

Looking forward to more steps. I need to do an EDI import routine, and think a CLR will fit he bill. Thanks!

Luis Cazares (1/9/2014)

---

Thomas Abraham (1/9/2014)

---

Let's try to simplify:

By default, "Options 1, 2 and 4 are equivalent and identical to the original code" is the remaining answer that has not already...

Let's try to simplify:

"Option 3 will always return an integer value for @Result" is false, as it is not GUARANTEED to provide a specific value for @Result when @AA...

Mike Hays (1/7/2014)

---

My simple guess is this setting would be turned off when you do not want the database overhead of statistics collected. This would probably be a very...

Thanks for the question!

Under what circumstances would you want is_auto_create_stats_on set to FALSE?

Thanks for the question on EAVs. They are a very controversial topic. I have designed databases that used them for PART of the schema. However, I always use them with...

A grain...

ronmoses (1/3/2014)

---

I figured a half-hour of research on this question was more than enough. I accept my fail. At least I didn't cheat! 😀

And since I've never reset...

+1 BTW, as written the code given...

george sibbald (1/2/2014)

---

I would read that If as an 'as well'. This is because the clustered index is still being dropped, but the data is moved at the same time,...

george sibbald (1/2/2014)

---

Thomas Abraham (1/2/2014)

---

Got it wrong as I was using http://technet.microsoft.com/en-us/library/ms176118.aspx as a reference and it says, in part:

If a clustered index is dropped by using MOVE TO, any...

Got it wrong as I was using http://technet.microsoft.com/en-us/library/ms176118.aspx as a reference and it says, in part:

If a clustered index is dropped by using MOVE TO, any nonclustered indexes on the...

Sad that 9%, er 1001%, selected answers that ended in 1!

Thanks for the question.