Statistics are not indexes. They just describe the distribution of data. If you have time to update stats nightly then I would do that. Time the reorg plus the stats...

Jeff, you're a gentleman and a scholar, and it distresses me that much more that I cannot make my point clearly. You have seen countless of my posts. I absolutely...

Jeff, I respect your position, however vehemently I might disagree with it. You make valid points but for me, xp_cmdshell is not and never will be cast in a positive...

Sergiy (3/26/2013)

---

...

Here is Erland Sommarskog saying to Microsoft "The first thought at hand is to use xp_cmdshell to run a DEL command, but xp_cmdshell is best disabled."

https://connect.microsoft.com/SQLServer/feedback/details/470000/make-it-possible-to-copy-certificiates-between-databases-without-the-file-system

If you have any doubts...

See, now here I thought xp_cmdshell was a virus. I learned something today:

http://sqlanddotnetdevelopment.blogspot.com/2011/06/sql-server-blocked-access-to-procedure.html?m=1

Sergiy (3/26/2013)

---

opc.three (3/26/2013)

---

Securing SQL Server by Denny Cherry:

- page 153 recommends to "disable xp_cmdshell"

- page 161 recommends "removing the extended stored proc xp_cmdshell" but goes on to say that (paraphrased)...

Securing SQL Server by Denny Cherry:

- page 153 recommends to "disable xp_cmdshell"

- page 161 recommends...

mister.magoo (3/26/2013)

---

How do we all feel about SQL Agent Jobs and the ability to run operating system commands from them?

(I know the user running the job will have been configured...

On second thought, count me out. How ridiculous...

DVSQL (3/26/2013)

---

Never ran those before, but it's worth a try I guess. Would tracing a single table be that much of a load onto the server? This table barely gets...

Great to know you got it sorted! Thanks for posting back.

I'm game.

I probably would not use Trace for this one. Consider adding a DML trigger temporarily to capture the inserted or deleted tables and the user making the changes to an...

I do not think you can affect the way the "Log Viewer" displays the data but if you log the output to a table it will retain the line breaks....