No announcements
Found 626396 threads
-
0 VotesWhy not always rebuild indexes?
If you want to rebuild an index with multiple partitions in an online environment, you need to rebuild the entire index which means ...Answered | 4 Replies | 4666 Views | Created by Mang Alex - Tuesday, October 18, 2011 8:56 PM | Last reply by pelegk1 - Wednesday, October 19, 2011 10:09 AM
-
0 Votes
why reorganize index is quicker than rebuild index ?
REBUILD rebuilds the index from scratch.Answered | 2 Replies | 4064 Views | Created by Ramakrishna k - Sunday, November 27, 2011 9:02 PM | Last reply by Ramakrishna k - Monday, November 28, 2011 8:04 AM -
2 Votes
Rebuild Index
Lower fill factor you have - more free space on the page you reserve when you rebuild the index.Answered | 2 Replies | 1611 Views | Created by Kalyan Chakravarthi (MCP) - Tuesday, April 2, 2013 12:18 PM | Last reply by Dmitri Korotkevitch - Tuesday, April 2, 2013 1:16 PM -
1 Votes
Index Rebuild
Hi, Why i am worrying in the sense, this weekend i am planning to rebuild/reorganize index in our production environment as part of maintenance.Answered | 19 Replies | 4094 Views | Created by VijayKSQL - Wednesday, August 7, 2013 8:07 PM | Last reply by Shanky_621 - Thursday, August 8, 2013 2:59 PM -
0 Votes
rebuilding index
I’m not quite sure the reason why you want to rebuild indexes.Answered | 4 Replies | 5347 Views | Created by krishna143 - Monday, September 6, 2010 6:22 AM | Last reply by krishna143 - Monday, September 13, 2010 6:24 AM -
4 Votes
Rebuild Index
I would start with UPDATE STATISTICS rather than Rebuild indexes, as from my experience it helps almost in all cases.Answered | 4 Replies | 3076 Views | Created by kimpurusha - Wednesday, November 21, 2012 11:18 AM | Last reply by Uri Dimant - Thursday, November 22, 2012 7:28 AM -
4 Votes
OFFLINE Index rebuilds vs ONLINE Index rebuilds
Can anyone please tell me the difference between OFFLINE Index rebuilds and ONLINE Index rebuilds?Answered | 4 Replies | 6990 Views | Created by Samantha v - Friday, September 19, 2014 12:38 PM | Last reply by Ashwin Menon - Friday, September 19, 2014 12:56 PM -
1 Votes
rebuild index
USE DBNAME; GO ALTER INDEX ALL ON TABLE1 REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON,STATISTICS_NORECOMPUTE = ...Answered | 11 Replies | 5825 Views | Created by neophytenik - Monday, May 18, 2009 4:20 PM | Last reply by neophytenik - Monday, May 18, 2009 6:45 PM -
3 Votes
Rebuilding index
Hi, What happens to tempdb when we rebuild the index in online?Answered | 3 Replies | 2131 Views | Created by Surya.chamala - Saturday, August 31, 2013 8:48 PM | Last reply by Sarat (SS) - Sunday, September 1, 2013 5:24 PM -
3 Votes
Rebuild Indexes
So, I am also considering them into the rebuilding of indexes.Answered | 9 Replies | 4083 Views | Created by Ronit Roy - Friday, February 3, 2012 6:46 AM | Last reply by eralper - Tuesday, February 7, 2012 6:23 AM -
0 Votes
Rebuild index
Decide Reorganize or Rebuild Indexes based on fragmentation level.Answered | 5 Replies | 1541 Views | Created by Surya.chamala - Friday, February 7, 2014 7:01 AM | Last reply by Praveen Rayan D'sa - Friday, February 7, 2014 7:38 AM -
0 Votes
Rebuilding index
Hello , Are you talking about Online index rebuild?Answered | 1 Replies | 1846 Views | Created by Surya.chamala - Thursday, October 3, 2013 6:24 PM | Last reply by Shanky_621 - Thursday, October 3, 2013 6:39 PM -
0 Votes
Rebuilding Index's
when you rebuild index, stats that are linked to the index also get updated.Answered | 7 Replies | 5555 Views | Created by SQLServer2k8 - Friday, October 21, 2011 7:57 PM | Last reply by Jeff Williams 3188 - Wednesday, October 26, 2011 1:15 AM -
0 Votes
Rebuilding Indexes
If there's no fragmentation, what's the point of rebuilding/defragging indexes?Answered | 7 Replies | 5215 Views | Created by Sunil Gure - Friday, June 8, 2012 7:28 AM | Last reply by Uri Dimant - Sunday, June 10, 2012 8:29 AM -
0 Votes
Rebuilding indexes
Ideally you should be monitoring the amount of index fragmentation.Answered | 6 Replies | 6320 Views | Created by mito access - Thursday, September 23, 2010 11:24 AM | Last reply by mito access - Saturday, September 25, 2010 6:03 AM -
0 Votes
Index Rebuild
Is there any way to minimize log file growth while index rebuild?Answered | 4 Replies | 1177 Views | Created by PraveenKumar_1999 - Monday, June 20, 2016 2:28 PM | Last reply by Shanky_621 - Tuesday, June 21, 2016 7:29 AM -
6 Votes
Rebuild Index
It is offline rebuild index.Answered | 7 Replies | 1634 Views | Created by Arup.mca - Monday, August 18, 2014 7:34 PM | Last reply by Arup.mca - Tuesday, August 19, 2014 7:46 PM -
0 Votes
Rebuild indexes and Reorganizing indexes
Thank you Shanky, I have one small question.After executing you provide query looks like .The column avg_fragmentation_in_percent value less than 5%.So in this ...Answered | 6 Replies | 1418 Views | Created by RAJ927 - Thursday, August 11, 2016 6:28 AM | Last reply by Shanky_621 - Wednesday, August 17, 2016 2:56 PM -
1 Votes
2012: disable/enable(rebuild) index.
Its always better to provide the options explicitly for REBUILD INDEX to avoid any miss.Answered | 9 Replies | 2791 Views | Created by jakubk - Wednesday, January 22, 2014 4:58 AM | Last reply by SQLZealots - Thursday, January 23, 2014 2:27 AM -
0 Votes
rebuild the indexes
Hi Srikanth, You can rebuild indexes using the Maintenance Wizard, or by running your own custom script via the SQL Server Agent or using DBCC DBREINDEX for ...Answered | 2 Replies | 4394 Views | Created by sambarisrikanth - Tuesday, December 15, 2009 8:05 PM | Last reply by Silvers Rayleigh - Wednesday, December 16, 2009 3:33 AM - Items 1 to 20 of 626396 Next ›
No announcements
