Costs are an estimated value base on a baseline machine from back in the 90's. They're extremely arbitrary and subject to all sorts of vagaries around the statistics of the...

That's a little bit fast. It's based on a cleanup process that starts with the complexity of the plan. The simpler the plan, the lower the complexity number, therefor the...

It still sounds like a permissions problem.

INT will sort faster then DATETIME but not radically faster. Have you updated the statistics on the index recently, maybe with a full scan. Is there a good data distribution...

The procedure cache can and does change. Procedures age out of cache as they are not accessed. It's a pretty normal part of the process.

If I understand the code and the explanation, I think you can change this to use a single pass through one cursor. Instead of a set of SELECT statements and...

Loading the output from a procedure into a temp table and then joining that temp table with your other tables is a good approach. As was noted, if you only...

Does the account that SQL Server is running under have access to that drive and/or share? It sounds like a security issue.

Steve Jones - Editor (6/2/2009)

---

Whether it's right or wrong, I come down on the side of allowing authors to have a voice and make their position known. I like the...

That thing made my head itch something fierce. It's gone.

Roy Ernest (6/2/2009)

---

Hey All,

Just thought I would give you an update on the issues raised by Grant and Mohit on TDE, it will be fixed with the latest release of...

That's a connection error. You either have the wrong name for the server, you don't have permissions to the server, or you don't have the right network settings on the...

I don't know if you'll find a single article that contains information on all those key words specifically as they relate to performance. Mainly because they affect performance in such...

There are gazillions. For example, I just started reading a book on SQL CLR (there's two right there, Structured Query Language and Common Language Runtime). On page 4 of the...

I'd strongly recommend reading Craig Mullin's book "Database Administration." It's a few years old, but it does a fairly good job of describing what a DBA is and does.