The execution plan is huge. Should I paste it as XML? I can't do a screen shot because it goes way off the screen in both directions.

Thanks Brian. The server is set to optimize for ad hoc queries. Developers writing their own queries seems to be on ongoing reality. Is there any other way to keep...

• This reply was modified 3 years, 2 months ago by  stevec883.

I

• This reply was modified 3 years, 3 months ago by  stevec883.

Thanks -- I was thinking that too. I have it going to a temp table now (to scrub the data) but will look into adding a section for the Inserts/Updates.

Thanks again for the great points. I will be able to test the snapshot and I believe the SAN disk being on a different SAN device could be a problem...

Thanks for the insight Brian. Some more information about the rollback is that it is a VM. I can stop the SQL service, disable it, and take a snapshot. I...

Thanks for the feedback Grant and Steve. So the docs do not discuss a stand alone instance. It seems by reading the info on clusters etc. that I would simply...

Thanks Michael -- the checkpoint command will come in handy for sure.

Thanks for the reply Jeffrey - that makes sense now.

Scott - Thanks for the reply. So when you stop the Agent, what happens to the jobs that were supposed to run during the stoppage? That's mainly what I'm concerned...

Thanks for clarifying Scott!

Thanks Jeff! I will defintely take a look at the scripts and approach. Appreciate the input!

Having been a sys admin for a long time, I do understand the separate worlds of developers vs everyone else, but sounds like a plan! I'll let you know how...

Thanks for your feedback Grant, and for confirming my suspicion. I was noticing the many many duplicate suggestions and thought it seemed extremely generic in nature. It seems it wants...

Very useful information --- I will keep that in mind, to not degrag an index that has the server default (of O% fill factor). I also like your % numbers...