Joy Smith San (4/22/2010)

---

Dear All,

One of our client was complaining that their application has become too slow now.

It used to be fast enough. I went there and checked the server.

Following...

Since it's an optional key word, I suspect as well that it's to support the ANSI standard. It may also be to keep the language consistent because you have to...

You can also use the logical name of the file if you have it.

DBCC shrinkfile('MyFileName',2)

But, shrinking files should only be done if you know, for sure, that the files aren't...

Lowell (4/22/2010)

---

Grant Fritchey (4/22/2010)

---

I had to know for sure, so I just validated it. I started a trace with no stop time, shut down the server, restarted the server, the...

You've actually already outlined most of the work involved. SSIS packages can be moved as files. To move the agent jobs, you just script them out and then run the...

It won't matter which database you run it from. Contention, despite the nolock hints, can cause things to slow down.

You do know that nolock doesn't just mean the classic "dirty...

How many databases do you have? That's how many transaction logs you have.

That article is a good introduction.

homebrew01 (4/21/2010)

---

Grant Fritchey (4/21/2010)

---

As far as I know, if you stop the server, the trace stops and has to be restarted.

Not the default trace. That's different. But it doesn't capture...

jcrawf02 (4/21/2010)

---

Pity that Brent will get kicked out of the MVP club so soon after his MCM... 😛

And now for something completely different...

Any advice on ridding my lawn of the...

jcrawf02 (4/21/2010)

---

GregoryF: "don't worry about not knowing how many instances/servers there are, every where I have ever worked, no one know all of them, there are some that are barely...

WayneS (4/21/2010)

---

sergei.gorelik (4/21/2010)

---

My security team would like to run SQL traces on one of our database servers. How can I restart a trace after a reboot? Is there any...

Lowell (4/21/2010)

---

am i reading this wrong?

i thought a server side trace starts when you run the command EXEC sp_trace_setstatus @traceid, 1, and runs continuously. rebooting or stopping/starting the...

Jeff Moden (4/21/2010)

---

Heh... I'll probably get slammed by the folks that like Oracle (not slamming them, though), but...

To start it automatically after a reboot? The only way I know is through the start up script which you don't want to run.

Michael Valentine Jones (4/21/2010)

---

Tell them to pay your boss everything they owe him first and you want a $10,000 retainer before starting any work.

That should cut off any further discussion....