The answer may have been different at the time of the writing of the question, but as time passed - none of the provided answers are correct at the point...

Here is an article with additional resources listed in the references section.

http://207.46.16.252/en-us/magazine/2007.03.sqlclusters.aspx

double post

If I am understanding your predicament correctly, your SQL server was also a Domain Controller. You have recently demoted that Domain controller to a member server.

Prior to demoting the...

As an extra piece of reading before proceeding down the path to locking pages in memory, read the following:

http://blogs.technet.com/askperf/archive/2008/03/25/lock-pages-in-memory-do-you-really-need-it.aspx

What is the fragmentation level of the indexes involved in this query (for the tables listed)?

Jeff Moden (12/8/2009)

When it comes to the differences between...

Bru Medishetty (12/8/2009)

Gail, I just saw that you edited it by the time I replied last time.

The OP...

Hey Scoobie...err Steve, where are you?

Your Scoobie now whenever I read something from you.

As for Alvin, well his...

Please post sample data and your table schema. This will aid in troubleshooting your scenario.

When I test these two queries, I get the same execution statistics, logical reads, scan count etc. Those results are with and without forced parameterization set.

In the plan, the...

That seems to be scaling about the same as my tests.

I do like the performance gains when a specific ID can be passed though. This script could prove very...

The wording in the explanation don't seem to match the documentation.

http://msdn.microsoft.com/en-us/library/ms191432(SQL.90).aspx

Explanation said that the view must not contain any deterministic functions. The referenced article states that functions must be...

I would avoid the shrink of the database. And certainly would not shrink the database to a point that releases all whitespace. By keeping adequate whitespace in the...

As an alternative, in order to prevent log growth, it may be worthwhile to grow the logfile substantially prior to the data load. Grow the log file to something...