I would have to agree with different parts of almost all the prior replies.  If I am hiring for an entry level position then having a degree related to computers...

This just seems like the next evolution of the accidental DBA to me.  Amazon and many other vendors are trying to offer these easy to use systems, and for many...

Steve,
Do you have an error in the first query under the 'Choosing what gets Trimmed' section?  Currently it shows the query as:
SELECT Result =...

From the Northeastern part of the U.S. my wife and I will be traveling to Missouri to visit relatives and see the full eclipse in August.  From there we are...

There are some fairly smart people on this forum, but I'm surprised only 5% of us expected a string STUFFed with a NULL would lead to a NULL.  I guess...

The installation steps are clear, but the reasons for doing this type installation are not quantified.  You mentioned that the performance "may" be better.  I think some examples of what performance...

On first read I did sort of like the idea, but I do agree with all of the disadvantages that TheFault brought up. Of course if this is more an...

Steve Jones - SSC Editor (3/25/2016)

---

DBA_Rob (3/25/2016)

---

I can't think of a SQL Server environment where I didn't end up needing to turn on mixed authentication, but when it comes to...

I can't think of a SQL Server environment where I didn't end up needing to turn on mixed authentication, but when it comes to the sa account I usually just...

At our shop we have literally hundreds of SQL Server installs (~800 at last count) and they run the gauntlet from 2000 through 2014. We have an embarrassing number...

About 80% virtual, but unlike many of the others that posted so far, our virtual environment is certainly worse performance than physical. Here we overload the virtual so much...

kkline (12/14/2009)

---

There was a time, back in the day, when table order used to matter. I think that it dropped off the list of things to worry about around...

I realize this is an old thread, but I found it while investigating partitioning a table. From what I have found, Michael Earl is correct. The fact that...

Jonathan Kehayias (1/11/2009)

---

One other thing to test for your larger database is the effect of parallelism waits CXPACKET on performance. My experience with VM's is that parallel processing is...