I have a theory about this: it says something along the lines of 'make sure that "XP_cmdshell" uses a windows login without much privilege'. I can't remember...

Doctor Who 2 (6/15/2013)

---

Good question, Steve. And I've read some of the responses (not all yet), and they're all great. I'd say that I don't believe I've ever worked in...

Yes. There has to be a transaction log, because if uncommitted changes have been written to disc and the system breaks...

DavidL (6/14/2013)

---

That might be stretching it, but I understand the point you were trying to make...

fchen 34442 (6/14/2013)

---

If I was a business owner (one day!), I would want my development team to be younger, being guided by those who have the experience to prevent, to...

Lynn Pettis (6/14/2013)

---

***************************************************

I am officially going to Afghanistan!

I leave for IRDO at Camp Atterbury in Indiana on Sunday, June 23rd. All should go well there with me leaving there...

Probably what came over you was your cat master.

Steve Jones - SSC Editor (6/14/2013)

---

Thanks for the correction, Hugo. Moving too fast today.

Not sure why you would disable a clustered index then. Perhaps it was included to keep consistent...

dropped scone (just translating "pancake" from Scots to English - and ignoring the American mistranslation of a good Scottish word as "flapjack")

This would have been a good question if the author had checked that it produced the expect result before he submitted it, and corrected it when he discovered that instead...

Does the Curator have a magic cat?

Lon-860191 (6/13/2013)

---

The problem is the missing answer #4: All of the above.

Because:

1. the query returns "0 rows" of data

2. because ShowPlan is on the Select statement does not execute

3. SQL...

Hugo Kornelis (6/13/2013)

---

Boy, how do I hate questions like this. No wait, the question is okay, it's the answer options.

If the question is "how many rows", the answer options should...

SQLRNNR (6/12/2013)

---

Steve Jones - SSC Editor (6/12/2013)

---

jasona.work (6/12/2013)

---

I have to wonder how often Gail and the other pros here get frustrated with people asking questions where the answer is in...

Caught again! 😀

The trouble with having a programming language with elements that are loosely based on natural language is that the people who devise them produce hard and...