As long as his salary gets spread among the people who...

Dean Jones (5/11/2009)

---

Also, I thought it was the other way around according to MS

To remove the trace definition you need to set the status to 0 (stopped) and then set...

Dean Jones (5/11/2009)

---

The value of the trace file is constantly at 0kb even though there are queries running on the system.

The trace file only gets populated if I restart SQL...

Bulk logged recovery just allows some operations (not many) to be minimally logged. The details are in Books Online and there are a lot of details. BULK INSERT, bcp, might...

Samuel Vella (5/11/2009)

---

Problem with the "point and click" interface of SQL Server is that a lot of DBA's can get through their day job without having to *think* about what...

Run a full checkDB. It won't kick users out, but it is pretty intensive and may slow the system down.

DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

kevinH (5/11/2009)

---

I've read that the primary key shouldnt be set on a "monotonic" col-- an identity column would qualify as that and I also get the impress that the correct...

No. Saw Wolverine. Pretty good, way better than the...

That's a huge topic and there's been a lot written about it. Start with google and see what you find.

Well, you can't script an encrypted stored proc so.....

Sure...

apinho (5/11/2009)

---

Do you know some link where I can see that "script objects / bulkcopy data" trick, thoroughly explained, so I don't make things worse.

A colleague of mine (Better DBA...

That's blocking, not deadlocks. Different problems.

You can kill the connection causing the block, but before you do, find out what it is. If it's a critical process that must not...

I just want to be 100% sure that there are no other errors anywhere else in that database. If the results of checkDB are identical to the results of CheckTable...

What's the error message?