title: Is It possible to a rebuild Index with out taking instance offline?
body: <p>I have this one <code>NONCLUSTERED INDEX</code> that's 85.71% total fragmentation and 55.35% page fullness. </p>
  
  <p>Can this be done without taking my instance offline and not enterprise edition?</p>
  
  <pre><code>TITLE: Microsoft SQL Server Management Studio
  ------------------------------
  
  Rebuild failed for Index 'idx_last_success_download'.  (Microsoft.SqlServer.Smo)
  
  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0038+)&amp;EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&amp;EvtID=Rebuild+Index&amp;LinkId=20476
  
  ------------------------------
  ADDITIONAL INFORMATION:
  
  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
  
  ------------------------------
  
  Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)
  
  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;ProdVer=10.50.2500&amp;EvtSrc=MSSQLServer&amp;EvtID=1222&amp;LinkId=20476
  
  ------------------------------
  BUTTONS:
  
  OK
  ------------------------------
  </code></pre>
  
  <p>After Reorganized:</p>
  
  <pre><code>ALTER INDEX idx_last_success_download ON dbo.TERMINAL_SYNCH_STATS 
  REORGANIZE;
  </code></pre>
  
  <p>I'm still getting 85.71 fragmentation?</p>
  
  <p>Using for my stats: <a href="https://msdn.microsoft.com/en-us/library/ms175008.aspx" rel="nofollow">DBCC SHOWCONTIG </a></p>
  
  <pre><code>DBCC SHOWCONTIG scanning 'TERMINAL_SYNCH_STATS' table...
  Table: 'TERMINAL_SYNCH_STATS' (331148225); index ID: 38, database ID: 7
  LEAF level scan performed.
  - Pages Scanned................................: 7
  - Extents Scanned..............................: 5
  - Extent Switches..............................: 6
  - Avg. Pages per Extent........................: 1.4
  - Scan Density [Best Count:Actual Count].......: 14.29% [1:7]
  - Logical Scan Fragmentation ..................: 85.71%
  - Extent Scan Fragmentation ...................: 40.00%
  - Avg. Bytes Free per Page.....................: 3613.9
  - Avg. Page Density (full).....................: 55.35%
  </code></pre>