That sounds as if you got it wrong. I can't resist asking which error did you make:

a) 11 is an even number; or

b)...

Fascinating isn't the word I would use for this discussion: the number of different wrong answers suggested...

Peter Trast (3/30/2010)

---

You don't like T-SQL much, do you? 🙂 Seems to have a bad effect on the condition of your...

Hugo Kornelis (3/30/2010)

---

Tom.Thomson (3/29/2010)

---

(...)There are a couple of additional things backup could do to improvve performance: at some point before starting to write pages to backup media, it could write...

Jim Lang (3/29/2010)

---

Yet still, if we are to keep government regulations off our pocketbooks, some method of certifying as secure would be needed. Would it be better to commission...

Festeron (3/29/2010)

---

Can I ask you about the other end of the backup?

At what point does the backup decide it's time to stop backing up, even though there may be transactions...

Gift Peddie (3/28/2010)

---

That is correct Microsoft also now provides one free that detects Trojans Trend missed but it is available to only Vista and Windows 7 users so there is...

Maybe I should have made this comment before reading and responding to other ones, but I don't think this will make much duplication.

If the US government attempts to introduce such...

Joshua M Perry (3/17/2010)

---

Whether they realize it or not, most large companies are already following government guidance for security compliance - anyone ever hear of ITIL? That is the...

GSquared (3/17/2010)

---

If there's to be government-induced security on the internet, I'd rather see it in terms of encouragement than regulation.

If, for example, antivirus software were tax-deductible, for both corporations and...

Because some time back someone told me that in cases where a page...

GabyYYZ (3/16/2010)

---

That being said, there are a few absolutes you can give for SQL Server:

1. Do NOT turn autoshrink on.

2. ummm...

3. ummm...

Come to think of it, as far as I...

Ron Kunce (3/22/2010)

---

IPossibly the reason that it is not already an option is because it would rarely be needed. Then again it does seem that it is those rare...

An option to rename the existing db instead of overwriting it might bevery nice, provided it would deal automatically with the required filename changes (can't have two DBs using the...

Excellent - this can be used to explain to junior DBAs why there is a limit on CTE recursion.