I'm trying to understand how sequential guid performs better than a regular guid. Is it because with regular guid, the index use the last byte of the guid to sort? Since it's random it will cause...

"An important aspect of simple predicates is their completeness; another is their minimality. A set of simple predicates Pr: is said to be complete if and only if there is an equal probability of a...

I have a large database (90GB data, 70GB indexes) that's been slowly growing for the past year, and the growth/changes has caused a large amount of internal fragmentation not only of the indexes, b...

I have a couple of tables (User & UserRecord) in my database that get extremely fragmented (like 99%) and cause the whole database and therefore the website to grind to a halt. UserRecord is ...