Hey Bennett,

For switching-in partitions - you're dead on.

As soon as you're doing "Updates" (via the MERGE) partition switching won't help.

I you have a way to split the "new...

If you can't guarantee that the data to be merged is focused at the most recent data, you have to consider the following example:

Data2010

Data2011

Data2012

Data2013

What happens in your system if you...

Sai,

To state the obvious: when you talk to them you'll want to leave out the part where you posted the queries they didn't want you to know about to the...

Since it seems you've been harnessed to the wagon of partitioning for good or evil...

The super cliff notes:

Things to consider before moving into partitioning...

-You want to partition on the clustered...

For posterity... the things we tried that worked, and some after-the-pain ideas.

The bug:

http://support.microsoft.com/kb/2344694

If you have landed here, and have a lot of change tracking numbers to increment...

Just to be clear:

I'm looking for the lightest weight method possible to increment the Change Tracking #.

In 10 years SQL (probably) would support more partitions... but what you're discussing is "multi-tenant" architecture.

Good article here re pros/cons of different strategies:

http://msdn.microsoft.com/en-us/library/aa479086.aspx

It may not matter, but keep in mind in the current SQL architecture you only get 1000 partitions per object.

You mention you've got 100 clients. How good is your...

I don't have an answer as I've never done this, but you're referring to a local server as the image storage location.

Is this email only going to an...

The fix:

OPEN MASTER KEY DECRYPTION BY PASSWORD = '<password>'

ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY

CLOSE MASTER KEY

My guess as to why this worked:

None of the keys/certificates were corrupted.

Somehow...

So far: I've recreated all the certificates / routes / remote service bindings.

Immediately after doing that, the transmission_queue error changes to: "Please create a master key in the...

Trade offs:

SSIS packages is much easier but has to be scheduled. If it runs every 30 minutes that would mean your xml packages could be 30 minutes stale. ...

Instant Initialization = Bacon saved

Thanks. Don't know why that basic info did come up in my morning o' Google.

Kudos!

-Jim

What kind of volume are you talking about?

Is the system keeping up currently?