I ran your query and i got no results.

No I don't, i don't know which process deleted this data file(This is for a third party app) . A couple of things i did notice, was that this...

no it is not.

thank you guys, the reason we are migrationg to only sql 2008r2 sp2 is that we have a very tight deadline to move over 10 production instances (4 months) out...

thank you George, would you happen to know any good best practices documentation for SCOM sql instances?

thanks again 🙂

yes thank you, we have done this in the past but with the same versions of sql server (sql server 2008 r2 sp2), my question was if this can...

thank you so much for that script! , one more question regarding this migration, these are fairly large dbs (1 terabyte) and the day we go live we would like...

Thank you guys, this is very helpful!

thank you guys!

yes! i am sorry, i was referring to Optimize for ad-hoc workloads option.

what about to flushed the oolder values from DMVs? We got metrics from sys.dm_exec_cached_plans prior to enabling. We want to check in a couple of weeks...

Thank you!

thank you.

Thank you Gila.