Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 10:44 AM
Points: 2,634, Visits: 3,985
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