Jeff Moden (8/27/2013)
BrerSQL (8/26/2013)
Sequential GUIDs definitely would make sense.I'm not so sure that's true. If the computer is rebooted, the start of a new sequence might not be > the largest guid already in the table. I think you could end up with massive page splits anyway.
Yes, but still at just a single point in the tree for the newly rebooted server. Still much better than the alternative in my experience.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service