I'm resigning as a Stack Overflow Moderator.
Thank you to everyone who has worked hard to make this Q&A site what it is.
I'm resigning for three reasons:
Stack Overflow Inc. has forgotten how to lead, how to persuade, and how to talk with the community. This has been a slow decline since 2014...
Currently, we partition data into physical databases based on the ones value of a monotonically increasing number - so a round robin distribution/sharding across 10 databases. The table in the database uses a composite key and we have ye-big-view to bring everything back together
I wanted to evaluate whether a partitioned view will improve performance as we always know the location value (the referenced monotonically increasing value) and it is part of the primary key
But, the check constraint must be simple to eliminate tables in a partitioned view so I can't use location_id %10 to check
Next thought was to make a persisted computed column that does the modulus and that would satisfy the check constraint but where would you put that in the composite key?
It's a constant so internet says we want a selective column first but mentally it feels wrong
We recently converted a table to memory optimized data. Our backups have all ballooned (3x300GB files to 3x600GB files for Full, 3x50GB to 3x250GB for Diffs), and startup has been getting progressively slower.
In an attempt to stave off these issues we converted the table in question to SCHEMA_O...
@dezso Sure. He'd been inactive for a long period of time due to changes at work etc (as he said himself in The Heap many times). Eventually there was a review and the diamond status was removed. Like any elected mod in good standing, he can reclaim it at any time, if his circumstances change.
You can use CHECKSUM_AGG. It only takes a single argument, so you could do CHECKSUM_AGG(CHECKSUM(*)) - but this doesn't work for your XML datatype, so you'll have to resort to dynamic SQL.
You could generate dynamically the column list from INFORMATION_SCHEMA.COLUMNS and then insert int into a ...
Anyone have any idea why someone would have different checksums on data that they say looks identical in different databases? Comments on an old answer of mine.
@CadeRoux it has to be a local machine generated seed for hashing
Now the question is does that live in master or on disk
I know that .NET does this on first-request but keeps it in the app domain during runtime. If you configure it in a config file you can force the same version across multiple machines.
@CadeRoux right. But I don't think a lot of MSDN articles talk about configuration values that default when they aren't specified in machine.config or app.config
@jcolebrand It would seem like it needs to be portable. It's supposed to be deterministic because you can use it in a computed column and have it indexed.
I'm resigning as a Stack Overflow Moderator.
Thank you to everyone who has worked hard to make this Q&A site what it is.
I'm resigning for three reasons:
Stack Overflow Inc. has forgotten how to lead, how to persuade, and how to talk with the community. This has been a slow decline since 2014...
