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

fill factor example ? Expand / Collapse
Author
Message
Posted Thursday, October 17, 2013 3:58 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 12:22 AM
Points: 43, Visits: 481
does anybody know over the net any good practical explanation with example on fill factor

===========================================
performance issue:
(1) Have you update the statistics on all tables of underling query?
(2) Are you using index well on the tables?
(3) Can you simplify your Query by re-writing it .
(4) are indexes are Defragmented well ?

Post #1505565
Posted Thursday, October 17, 2013 5:20 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 4:48 AM
Points: 2,834, Visits: 3,950
See thses links

http://www.sqlservercentral.com/Forums/Topic1102684-1291-1.aspx
http://www.brentozar.com/archive/2013/04/five-things-about-fillfactor/
http://technet.microsoft.com/en-us/library/ms177459.aspx


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1505615
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse