who's stopping at the slice of pie?

Pecan, lemon meringue, apple, cherry - give me the whole pie 😀

For SQL 2000, this method seems to be the...

Thanks Jeff:cool:

Effective testing would be much the same as the QA process for releasing an app to production.

Run through your test plans, test the application and verify that everything is still...

In addition to the Disk alignment (typically more of an issue on disks formatted by MS OS installs), is to verify the Allocation Unit size (4kb v. 8kb v. 64kb...

Gail has provided sound advice. Also consider the additional performance hit (small as it may be) you are experiencing due to the maintenance of those duplicate indexes.

Test your queries...

Grant Fritchey (11/25/2009)

---

However, once you have a set based process (and yes, please do this first), yes, usually when doing large scale data loads I've found that dropping the index...

It is a nice idea. One problem is that, even though I scroll to the end of the text, or click that I have read it - did I...

The likely reason the DBA does not want to move it is due to hard-coded connection managers to the dev environment. Due to that the DBA is recommending the...

Please attach the actual execution plan.

Are you inserting into an updatable view? IS the query time 4, 16, or 21 seconds, or all of the above?

try this

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/5637cfef-6078-4bc0-bce2-a4175b45e23a

Thanks Grant for the link. Interesting thread it was.

To follow up on Gails post, the dropping and recreating of the mirror may not take too much time on a 200MB database - but what about when that database...

Same info as Atul and Schadenfreude-Mei. Time to extend the database in % gets larger as the growth gets larger which can cause performance issues. To better control...

Though not in the initial question, I need to ask how you are actually getting the Updates. Is automatic updates configured to receive the updates directly from the website,...