You really need to evaluate the system. Bare minimum you need to be sure the statistics are getting updated regularly. You should also look into tracking down a script that...

You really need to evaluate the system. Bare minimum you need to be sure the statistics are getting updated regularly. You should also look into tracking down a script that...

We spent several days chasing down why a query was running twice as fast on a test box as it ran in production. Then we noticed that the test box...

Always stored procs.

If the order or where clause is radically variable, you may have to generate a dynamic statement within the stored procedure (totally frowned on, but possibly necessary).

Think about...

Depending on your experience, this could be a tough transition. You need to learn to work with and like developers. I'd work on db design, advanced tsql programming, xml, and...

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...