Delete fewer records at a time. You might be experiencing some delays from logging.

When you say you have the necessary indexes, that doesn't really explain things. Can you give some...

Is this SQL Server 2008 or R2? There are some differences in the documentation. This shows that R2 has stricter validation requirements.: http://msdn.microsoft.com/en-us/library/ms189067.aspx

I haven't done this in a few years,...

According to Michael's link, compression (NTFS, not third party) is supported for NDFs only, not MDFs or LDFs.

Quote: Data compression is supported for user data stored in read-only user-defined (.NDF)...

Revenant (2/13/2012)

---

Paul, what do you...

OK, I hadn't noticed the blog post items, but they shouldn't appear. I'll see if we can get a fix in.

Jeff Moden (2/12/2012)

---

Does anyone know how to block "Site Owners" in the "Recent Posts" for today? Although I certainly appreciate links to blog subjects, it's gotten way out of...

codebyo (2/12/2012)

---

tony.turner (2/12/2012)

---

MCM is not really open to us in the third-world (...) Even were it to be available, the price (after currency conversion) relative to salary or contracting rates...

TravisDBA (2/13/2012)

---

Steve,

It's tricky. Even if all I had to go on were ZIP code, birthdate and sex columns, I could still probably find out who you are. But on the...

Richard Sisk (2/10/2012)

---

It works quite well, we have key change procedures that are used to regularly update the keys. If a backup is stolen, it's no good unless they also...

Worth the read: http://www.newyorker.com/reporting/2011/10/03/111003fa_fact_gawande

Nadrek (2/10/2012)

---

I would say hashing should be done on the application side at this point, because

A) SQL Server does not provide us modern hash algorithms (i.e. the SHA-2...

Good advice from Ron. I might also say give it a chance, and let some of the DBA stuff go. Or let it happen slower. They may decide to move...

Proper beer?

Who cares. Beer, wine, liquor are meant to be enjoyed....

Hugo Kornelis (2/8/2012)

---

So I disagree that the minimum version should be included in all QotD questions. I think we should all assume that questions apply to supported versions of SQL...

michael.kaufmann (2/9/2012)

---

I'd second this; it's my understanding that concatenating a fixed string as salt (in Steve's example assigned to a variable) to another string can't be considered a salt parameter,...