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 12»»

Who Cares about FillFactor? Expand / Collapse
Author
Message
Posted Sunday, November 16, 2003 12:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 29, 2014 12:39 PM
Points: 110, Visits: 495
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/gjackson/whocaresaboutfillfactor.asp

Gregory A Jackson MBA, CSM
Post #18259
Posted Wednesday, November 19, 2003 6:22 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: Moderators
Last Login: Tuesday, August 26, 2014 8:57 AM
Points: 8,369, Visits: 736
I want more, can't wait till the next article.




Post #87254
Posted Wednesday, November 19, 2003 7:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 2, 2014 8:21 AM
Points: 168, Visits: 423
I'd like to see results of actual experimentation - actual change in performance, numbers of physical I/Os for different physical configurations.


Post #87255
Posted Wednesday, November 19, 2003 8:03 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, November 8, 2013 3:39 PM
Points: 349, Visits: 49
I enjoyed Greg's article and am hoping that my article on Fill Factor's is one of the two for this week. Greg brings up a good point with PAD_INDEX!! I truly believe that Fill Factor settings are important and have made major performance improvements by adjusting them in my databases!!!

....Here's to hoping my article shows up next






"Keep Your Stick On the Ice" ..Red Green
Post #87256
Posted Wednesday, November 19, 2003 10:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 12, 2007 5:10 AM
Points: 13, Visits: 1
Great article, well written. Fragmentation is not the easiest SQL Server topic to get your head around, but this explained fill factor and fragmentation in easy to understand English.




Post #87257
Posted Wednesday, November 19, 2003 10:43 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Friday, August 29, 2014 8:46 AM
Points: 6,783, Visits: 1,881
Jeff, your article is this week.

Andy
http://www.sqlservercentral.com/columnists/awarren/




Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #87258
Posted Wednesday, November 19, 2003 10:47 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 10:14 AM
Points: 477, Visits: 727
Thank you! Looks like this is going to help me today.

Regards,

--SJTerrill




Post #87259
Posted Saturday, July 9, 2005 6:44 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 23, 2010 4:26 PM
Points: 8, Visits: 8

Excellent article....

Thank you!  I am currently working on a project to migrate data from an old database to a brand new database.




Post #199088
Posted Thursday, February 16, 2006 10:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 29, 2009 10:04 AM
Points: 7, Visits: 2
Thank you.  Excellent article.  Clear, concise and very helpful. 
Post #259115
Posted Thursday, March 16, 2006 10:29 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 30, 2007 2:12 AM
Points: 46, Visits: 1

Brilliant!

Thank you - totally demystified and no longer something I consider a threat to understand.

Please keep it up!

Post #266298
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse