CLR that accesses the database uses the same query engine as anything else that accesses the database. It won't query any faster, insert any faster, etc. What it...

Are you familiar with inline queries?

You can break up an aggregate query with those.

This is a sample of how they look:

select ID,

(select sum(MyColumn)

from MyOtherTable

where...

I'd use VB.NET to create a text file, and then step through a dataset row by row and write the data into the file. It's pretty easy to do....

When I want that kind of security isolation, I separate by database, not by schema. Much easier to manage.

I'd have to see samples of the scripts you're using for...

Then you'll need to escape the single-quotes in the parameter value. You do that by using two single-quotes in a row.

I haven't tried mixing them to that extent.

Have you thought about running these in separate VMs or something like that?

Sounds like a problem with the metadata for the database. Have you run DBCC CHECKDB on it?

Honestly, I'd just take a look at the tools on Red Gate's site (link at upper right of this page, since they own SQL Server Central). They have a...

You could probably pass the looping to one, but the gains will almost certainly be microscopic in the scope of the code.

A simple T-SQL while loop will probably be good...

You need to put single-quotes around the values in your delimited list. Like this:

'value1','value2','value3'

I'd say start with your business needs and work from there. If you want someone to design it for you, hire a contractor.

There are off-the-shelf products that do that...

And don't bother allocating more RAM till you've checked those things.

If the waits are I/O related, or CPU related, then there's no point in allocating more RAM. I'm betting...

Run the query Ninja posted. It might help to read the articles Steve linked. Start from there.

The problem with xp_cmdshell is that, if the account privileges are set even slightly wrong, it allows all kinds of nasty things to be done to the server.

It can, if...

Not that I know of.

Entity Framework doesn't allow you to control the options on the connection?