Nope. SAFE Assemblies work just fine. How much trouble you have with the EXTERNAL_ACCESS one depends on how you deployed it. IF you used a key to...

Well first you have statics that aren't readonly which is both UNSAFE and fails to guarantee valid results at any point of your execution. What exactly are you expecting...

What safety level are your assemblies? That is what determines the level of headache you will have at failover and during deployments.

Jonathan Kehayias (1/11/2009)

---

One other thing to test for your larger database is the effect of parallelism waits CXPACKET on performance. My experience with VM's is that parallel processing is...

Generally, you would patch all instances at the exact same time. If you have a multi-instance server it lets you select which instances to apply the patches to.

colin Leversuch-Roberts (1/21/2009)

---

much as I dislike VMs I have never encountered turning off parallelism, that could be a serious hit and I'm pretty sure this is untrue. I guess some...

george sibbald (1/21/2009)

---

a long thread here but I don't think this has been asked\answered -

the article mentioned that VM streamlines the DR process, but for that to be fully...

GilaMonster (1/14/2009)

---

I'm not sure how to fix this. Since it's a vendor app, you can't make changes to the stored procedures and, with sharepoint, even adding indexes isn't allowed. If...

GilaMonster (1/12/2009)

---

That was about a week before he referred to me as a "clueless idiot" in a mail to my manager after I had requested RAID 10, dedicated disks for...

Steve,

Google Reader returns "Permission Denied" if you try to subscribe to the RSS Feed on that new forum.

If this is on SQL Server 2005, try using the blocked process report to identify the blocking statement and object and then look at the code/indexes/physical design and determine how...

What rights/roles does your user account have on both servers?

Thanks Steve, I'll add it to my feed reader in a minute.

Look in the Windows Event Log and see what errors get logged if you try to restart the SQL Agent. If there aren't any, then recheck the LOG path...

You can use the DTS Migration wizard to move to 2005. You can also save packages to the file system from both DTS and SSIS and then import them...