Do you consider "makes no money" and "is not a profit center" to be the same thing?

I don't know whether MSFT makes any money...

Very well said, Matt!!

He does .... or have you never heard of...

blandry (3/30/2010)

---

I am tired of this debate and can only address it as I know it...

The best DBAs that I have seen, worked with, or had work for me, DID...

I'm guessing that the OP did use the correct query because he said that it returned 0 rows. Otherwise, the query shown would return all rows except where they were...

I could really go for some popcorn while I watch the show.

You need to run the whole thing and not just the snippet posted above.

Are you saying that the procedure cache is not...

We can't say definitively that that is enough RAM. It depends on the workload and traffic rates more database size and number of databases. For very intensive OLTP applications, such...

The cached plans are stored in the bufer pool. In act, it's generally the largest part of the buffer pool.

You can improve the cache hit for your plans by forcing...

Excellent!! That's why I always ask those types of questions, because even the most experienced person sometimes overlooks the simplest thing. I know I do.

I call this an "is it...

First things first, this is probalby just a typo in your post, but you said that "The server network address "TDP://<FQDN>:<port>".

Can you verify that you are using TCP and not...

Ah, nicely done!!

You can do it that way, but then it will take a longer time to sync up again because the mirror is doing nothing during the batch processing. This increases...

I think what nick posted makes a lot of sense, but I think it is really more geared toward daily management of the system. Before you start making changes for...