1) I'd use the same database for all customers. If customerA has feature X and customerB has featureY, use separate tables. That way you can easily "turn on" features for...

What I do is more work to setup, but it works great, and handles failures of servers better, IMHO.

I have a db on each instance which is standard. It collects...

Don't use named pipes. Used TCPIP

Reference fixed.

If you're going to a latest schema, you could use SQL Compare from Red Gate. There's an API for scripting, and you could compare to a backup file or even...

Glad to see everyone behaved, and yes, I had a great day on the slopes at Keystone.

Jeff Moden (1/26/2012)

I've not experienced any noticiable...

GilaMonster (1/26/2012)

I've had that. It was followed by almost R10 000 repair bill for replacing the gaskets in...

True, you can use views of synonyms. That might work, although performance wouldn't be great.

For dev/test, it's probably fine.

You have three choices

1. delete 30GB of data

2. move data to separate databases. Meaning either move a portion of data from each table to a new database

3.move certain tables to...

Is that a "yes"?

BTW,...

Why do you need to move to Express? I'm asking, so that I can try to see if there is something you can do.

The short answer is no, you need...

I would concur with Jared and Gail here. The licenses seem to read, to me, that you cannot use other systems for analysis or reporting of live data, but if...

Why do you want to reduce the file size to 20GB?

Second, if you have a 40GB file, with 1GB unallocated, then you have 39GB of data. If you need to...

I changed the question too, to note that the shrink runs shorter.

It's certainly a strange behavior, and one I'm not sure I like.

I think I'll refund all points for now.