September 12, 2012 at 2:50 pm
[p]
Higly transactional table should not have Clustered Indexes
Highly transaction table should not have Fill Factor in index definition
[/p]
What does the above statements really mean? Does that mean that tables where there is huge amount of write operations should not have Clustered Indexes and Indexes should not have any fill factor?
September 12, 2012 at 3:51 pm
Well, both of those statements are incorrect, so probably better to just ignore them...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 12, 2012 at 4:27 pm
GilaMonster (9/12/2012)
Well, both of those statements are incorrect, so probably better to just ignore them...
Quite true.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply