Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««123

Table Designing Expand / Collapse
Posted Tuesday, July 8, 2014 8:35 AM



Group: General Forum Members
Last Login: Today @ 12:16 AM
Points: 2,997, Visits: 4,957
Grant Fritchey (7/8/2014)
While I'm not a fan of GUIDs as clustered keys, I've seen it in a production system and it wasn't the end of the world. We did have to deal with some excessive fragmentation issues and the obvious problems of fewer rows stored per page were there. Performance was reduced. It's absolutely not a choice I would make, but if you're already neck deep into that style of design, I wouldn't recommend a complete rewrite and redesign, but you should sure as heck go into it with your eyes really wide open so you're not surprised by some of the issues that are bound to come up.

Those tables were already in place and they dont have any plans to change at this moment.

I got the request for this table designing and with help you all experts I gave my recommendation. Avoided GUID because its not sequential and takes 16bytes space.
Post #1590394
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse