CELKO,

I'm learning a lot though this process, thinking much more carefully about how I should organize my CIs.

Dave

Hi Jeff. That's my whole question really. Is there a good way to fix this and is it worth trying to fix.

True using a UDF to generate the UUIDs will...

Jeff, there are zillions of lines of app code that have queries joining on and referencing the UUID.

Hi Tom.

It's counter intuitive, but that is how SQL orders UniqueIdentifiers.

Thanks for your help opc.three.

One last thing: I hate to leave less than optimal code out there for posterity so here is my last, optimized function with all string...

Our web-based app exposes these IDs in the URL. Although their is additional security checking when executing queries based on the passed in URL UUID, in our shop it...

opc.three:

Currently we have an integer identity, so I imagine I could draw a line in the sand and say all records with an identity of < X go to partition...

Thanks for all the comments. I have one more idea for addressing this. I'm thinking about partitioning my table. Everything that has already been created with the...

Hi opc.three. Thanks for the reply.

Yeah, for the most part the UUIDs are generated in the app layer, though there is some default constraints in the dB.

As luck would...