Since SQL Server 2000 is off the main stream support path, how about the fact that if a mandatory security patch comes out that breaks 2000, you can't count on...

Can you save the actual execution plan as a .sqlplan file, zip it and attach that? Without all the underlying data it's hard to read an execution plan.

I'm sorry, I've never seen that one occur before. On a guess, someone did it. Especially if it's everywhere.

Yes. You can apply controls to it directly so that it only uses a single CPU and limited memory. It means that the auditors will actuall make less impact on...

Thinking about it further, would this be construed as a test system? Then you don't need to buy a license for it.

Either way, if you really have to let them...

sam (4/28/2009)

---

We're just finishing up our migration of 170 dbs to...

GilaMonster (4/28/2009)

---

Paul White (4/28/2009)

---

edit: P.S. In your reply to Tao Klerks in that thread, is it not true that many plans can be in cache for the same proc? ...

Oops. I misread what they had created. Sorry. I saw it as a compound index. My bad.

Oh, and Tom Larock has a new article [/url]over at Simple Talk on using Audit.

You might look at Change Data Capture. Here's an article on auditing on MSDN. That might help.

I've had 2000, 2005, 2008, and four different versions of Express all running at the same time on an XP box. No issues. Well, except that it's slow as hell...

Yikes. That won't be easy. I'd try using a UNION between each of the different databases, assuming you know what they all are. That way, any given query against any...

Have you read through the topics in the Books Online (documentation included with SQL Server). I think it explains parallel query execution pretty well.

By and large, there's little that you...

You should read Gail's articles first. They'll answer a lot of your questions. You might want to pick up Kalen Delaney's book Inside SQL Server 2005: The Storage Engine to...

They are. Just not to the extent of other resources. Steve has a pretty open policy and lets people learn by writing articles. Yeah, sometimes that leads to... interesting... results,...