Hi Lynn,
Whenever a CLR module invokes resources that cannot be provided within the SQL Server itself, the assembly must be set up for External Access or Unsafe execution. A...

Hi,

For those who may find this thread interesting, I'll lay out my scenario in more depth and how Eirikur's suggestion to resolve my challenge.

I manage a...

I appreciate the fresh styling and the column format looks very clean. However, I concur on the fact that I don't read this content on a mobile device. Opening it...

I suppose that the simple response would be to say that it is an issue of time. Like other commentors, I have more customers/projects beating at the doors of my...

Well, just tonight I've wrapped up my work on this issue and thought I'd post my findings for those who might find it useful.

When the problem between the lab...

Teal,

Thank you for the long response. I've reviewed again a number of the points you brought up and have branched out on a few other areas as well. I'll summarize...

Ok... so here are some new information:

I moved the TempDb to a separate ESATA drive on the server. My initial thought was that things seemed a little better but 5...

I appreciate all the responses giving me additional things to consider.

A little more color to fill in on the details. The servers both run 4 mirrored SCSI volumes for...

I've read through the examples and find the variety of techniques interesting. When I had to solve the problem I was looking at fixing the data as it went into...