It depends on how much the data changes....

Have you evaluated the execution plans for both queries? The second has a correlated subquery, but that really shouldn't make much of a difference because it's effectively doing the same...

If you are not a partner or do not have premier support, you have to request it as per the Microsoft request channel given in the support KB article. They...

Can you post what is being done in the maintenance plan? That can give us a better idea. As Jeff indicated, there are some operations which can hamper performance depending...

Can you post the query (remove or change any sensitive information)?

You must also configure in the local security policy for the service account SQL Server is running under to have the right Lock pages in memory.

SQL Server only uses 2...

Where is the SQL Server installed? And what service pack is it?

I've run across organizations who have titled folks "Senior Sybase DBA" for a guy who had 0 days of experience with the product when first receiving the title and putting...

Jeff Moden (11/23/2007)

---

Maybe the new security features for parts of the server that point to the outside world and the fact that MS won't support 2k soon are worth it......

Jeff Moden (11/23/2007)

---

But, I believe the point being made is the kid didn't automatically label himself a Senior Software Engineer after the SMS fix. Carrying that title also carries...

Yup, and if you ask me which tool *I* am going to use, I'm not going to use SAC because the only thing I'm concerned about is getting the Netlibs...

GilaMonster (11/22/2007)

---

And you call yourself a senior software engineer? Personally I'd consider anyone under 2 years junior.

Someone claims...

Good programmers are the ones who tend to think through a problem before writing code. I don't mean they sit there and whiteboard and model everything out. Some can do...

It has better better security options, among other things. For instance, DDL and Login triggers, which can prevent schema changes and modifications to critical logins. Also, for those SQL Server...

Kalen Delaney, in Inside Microsoft SQL Server 2005: The Storage Engine, makes the point that there is no coordinated memory management between instances of SQL Server installed on the same...