For...

deroby (7/6/2012)

---

Hi Gail, another thanks for the series!

We've always used the 'rule' that every table needs a clustered index and I've never really challenged that. If the PK is lean...

TheSQLGuru (7/5/2012)

---

The people who want encryption/decryption to be done out in the .NET layer somewhere are ABSOLUTELY correct (or at least best practice). Anything you tell SQL Server to...

Why are you not using WITH CHECKSUM?

Adam Seniuk (7/4/2012)

---

Best way to test this out is to go and get a good 60GB desktop grade SSD with a high published random IOPS rate plug it into your...

The same advice holds true for a DBA learning to program as anyone else learning to program; determine your goals.

For any DBA, I'd say learning SQL would be the most...

1) Good security is more expensive, and increases how long all work takes, and increases how difficult it is.

1a) Your competitors have less security than you... and thus...

Be aware that up through 2008 R2 at least, Windows Group logins are not able to set a default schema.

https://connect.microsoft.com/feedback/viewfeedback.aspx?FeedbackID=238246&siteid=68

D. Clark (6/26/2012)

---

I couldn't agree more. The devs before me used maintenance plans, but I am actually planning on getting away from them. My biggest gripe so far is that...

Note that your password is very weak for production. If you're going to use any password at all for automated encryption, it should be as long as is practical,...

I generally structure backups to handle all SIMPLE recovery model databases one way, all FULL and BULK_LOGGED recovery model databases another way, Master (which gets Full backups whenever SIMPLE databases...

Sean Lange (6/20/2012)

---

I too have struggled with this occasionally. I use this splitter in a lot of very unconventional ways. For example say I want to find all anchor tags...

Stueyd (6/18/2012)

---

But i'm still unclear.... If I have a column with an identity primary key which has a clustered index (with is continually having data inserted amd deleted) and this...

SQLKnowItAll (6/15/2012)

---

I did; my post stands.

Yes, the other posts did help the question posed by the OP in a simple way,...

Unless, of course, you can spend the time to do performance tuning and only add back what's actually required.

If that much...