The only time we've maxed out at my current company, and we have, was when we built a really bad database that pegged the cpu's on a 4-way server. Some...

HAVING MAX(YEAR) = 2006

Looks like it should work...

Thanks for the response.

I did post this also on MSDN. I just came over here for third party help. I didn't expect to see you.

I also posted the question...

Can I skip the CD's and pack a couple of books of equal size instead?

I can live without music.

I've used both (and wrote articles on both). I think the TSQLUnit is a more pure version of unit testing than DBPro. TSQLUnit also has pretty good reporting capabilities on...

You're 100% correct.

I actually thought that was what I said.

You get all the functionality I've talked about without any of the server components. The server adds in all the Team activities like Work Items, Team builds, shared documents, etc.....

Now we're both learning. I never noticed that before either.

Thank you.

Yeah, I've noticed the same thing. When a line of code extends past the edge of the screen it shoots ALL the text out there too. It does make things...

I agree. Best measure is either to use the STATISTICS TIME or Profiler.

Interesting point, don't use both because you'll get confused. We found that there are small differences between the...

What you usually see in the STATISTICS is the time on the server. It doesn't include time to move the data to your machine or time to display the graphics....

2005 uses SMO.

Several people have commented that they use NOLOCk or setting the isolation level because they're in a read only environment. Have any of them considered setting their database to read...

Just an idea. Buy vs. Build always has trade-offs in either direction.

There are other text indexing products out there. Shop around.

Is there an INNER JOIN involved to arrive at the data being selected. Join criteria is evaluated prior to the WHERE clause and you can sometimes move things from the...