Hi

Did the table(s) that you did compression had any XML datatype columns in it?

I am been doing some prototype where I see that compression does saves a lot...

Hi,

As per my experience planning to go for SQL Server Service broker implementation is a novel thought, but in reality, at certain point where database sizes are very large, and...

I am concerned with hash as a bad primary key. But no choice.

Calling program have limitaions to provide person's info as XML to store, and then send the person's XML...

Hi Elliott, Lowell

Here is the psuedo code that I tried to come up with.

Question is What approproriate size of "InfoHash" BINARY should be?

I tried sampling and looks like BINARY(20)...

Hi Lowell

You are correct in reading the details. May be my details were not complete

Yes it is surprising but still a requirement.

The field comes in as XML... Needs to hashed...