Good enough

Forgot to add the link for the msdn reference showing that Vardecimal is a read_only attribute in 2008 and above with it being enabled on all "user" databases by default

http://msdn.microsoft.com/en-us/library/ms188124.aspx

The...

Gary Varga (11/13/2013)

---

SQLRNNR (11/12/2013)

---

Vardecimal existed only in SQL 2005. SQL 2008 introduced compression (row and page). While vardecimal is a form of compression, the fact that it only...

Though i understood what the OP was trying to achieve I don't like this particular question and I don't like the supporting documentation.

Vardecimal existed only in SQL 2005. SQL...

Thanks. Straight forward enough of a question.

buzz

Here is a pretty good resource for that.

http://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/

2GB for the OS is too low when you have 32GB of memory. The OS will use more than 2GB.

And this one

http://www.sqlskills.com/blogs/jonathan/wow-an-online-calculator-to-misconfigure-your-sql-server-memory/

Grant Fritchey (11/7/2013)

---

The other recommendations for MAXDOP are good. You can also leave it at zero if you're not experiencing any particular CPU pressure.

But, the one thing I would suggest...

r.stebbens 78867 (11/8/2013)

---

Mighty (11/8/2013)

---

paul.knibbs (11/8/2013)

---

I kind of agree with waxingsatirical...it never occurred to me anyone would think this works otherwise, and I spent a good few minutes trying to figure...

Jeff Moden (11/7/2013)

---

If you want it real bad, that's the way you'll get it.

Rework costs at least 8 times more than doing it right the first time.

Your customers are the...

Tom John-342103 (11/7/2013)

---

If "a little clunky" means that the application is good enough, then by all means roll it out. Because "good enough" delivered today beats perfection delivered tomorrow...

erroneous

swwg69 (11/6/2013)

---

Everything old is new again. Back in the day, I packed a machine with RAM, created a VDisk and assigned tempdb to the VDisk. The machine's performance...

Jeff Moden (11/5/2013)

---

Heck no. I leave...

not sp_configure??

:w00t::-D