No announcements
Found 1263961 threads
-
0 Votesrebuilding index
I’m not quite sure the reason why you want to rebuild indexes.Answered | 4 Replies | 5257 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 | 3014 Views | Created by kimpurusha - Wednesday, November 21, 2012 11:18 AM | Last reply by Uri Dimant - Thursday, November 22, 2012 7:28 AM -
0 Votes
Rebuilding indexes
Ideally you should be monitoring the amount of index fragmentation.Answered | 6 Replies | 6255 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/reorganized
How many rows are in your table and more importantly how long does it take to rebuild an index.Answered | 1 Replies | 5513 Views | Created by s_des - Thursday, October 29, 2009 2:48 PM | Last reply by Adam Haines - Thursday, October 29, 2009 3:07 PM -
0 Votes
Rebuilding Clustered Indexes
Hello Two things, 1.Yes your index is fragmentated(note some conditions exists :-index-rebuild-doesnt-affect-fragmentation)- you have ...Answered | 6 Replies | 1346 Views | Created by rajesh kumar - Thursday, July 23, 2015 5:12 AM | Last reply by Rama Udaya - Monday, July 27, 2015 8:24 AM -
0 Votes
Index Rebuilding in Logshipping
However, we don’t recommend that you rebuild indexes often for a log shipping scenario since rebuilding indexes may cause huge logs which ...Answered | 6 Replies | 21269 Views | Created by Sathyalan - Saturday, January 23, 2010 12:29 PM | Last reply by MSSQL DBA - Friday, February 11, 2011 6:42 AM -
0 Votes
On Rebuilding Indexing
Do not rebuild blindly all indexes, take a look at http://ola.hallengren.com/ Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ ...Answered | 1 Replies | 4639 Views | Created by Jawad Siddiqui - Thursday, September 8, 2011 7:06 AM | Last reply by Uri Dimant - Thursday, September 8, 2011 7:10 AM -
0 Votes
Rebuild Index improves the performance ?
A clustered Index is usually recommended.Answered | 5 Replies | 1231 Views | Created by Vaibhav.Chaudhari - Friday, August 30, 2013 7:23 AM | Last reply by Andreas.Wolter - Friday, August 30, 2013 10:11 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 | 4331 Views | Created by sambarisrikanth - Tuesday, December 15, 2009 8:05 PM | Last reply by Silvers Rayleigh - Wednesday, December 16, 2009 3:33 AM -
0 Votes
Statistics and REBUILD indexes
Hi subu, About rebuilding indexes, you can review Prashanth’s post.Answered | 8 Replies | 1309 Views | Created by subu999 - Tuesday, August 26, 2014 2:06 PM | Last reply by Lydia Zhang - Wednesday, August 27, 2014 6:54 AM -
3 Votes
rebuild index fail
Also the rebuild index task was successfull so is it not supposed to take care of this problamatic indexes.Answered | 6 Replies | 5241 Views | Created by Ramshna - Tuesday, September 6, 2011 7:01 PM | Last reply by Ramshna - Thursday, September 8, 2011 3:19 PM -
0 Votes
Rebuild indexes and Reorganizing indexes
Thank you You need to first download the script then copy the script.Answered | 6 Replies | 1336 Views | Created by RAJ927 - Thursday, August 11, 2016 6:28 AM | Last reply by Shanky_621 - Wednesday, August 17, 2016 2:56 PM -
0 Votes
Rebuild index
I can rebuild an index, can I rebuild a table?Answered | 6 Replies | 1854 Views | Created by Sudhakar Vallamsetty - Thursday, June 5, 2014 9:24 PM | Last reply by Uri Dimant - Friday, June 6, 2014 9:06 AM -
0 Votes
Databasesize increase after Index rebuilding
You are right that you need rebuild/reorg only fragmented indexes.Answered | 2 Replies | 4251 Views | Created by happy-5 - Monday, July 25, 2011 7:48 AM | Last reply by John Sansom - Monday, July 25, 2011 8:57 AM -
0 Votes
Time it takes a rebuild index
There is some way to calculate how long the index rebuild will take to get a total estimate of the 100 that need maintenance.Answered | 9 Replies | 2558 Views | Created by Camilo Ponce - Friday, July 13, 2018 4:32 PM | Last reply by Shanky_621 - Tuesday, July 17, 2018 1:29 PM -
1 Votes
Error on Rebuilding Index
leaving the options and just using alter index [index] on [table] rebuild does produce the same errorAnswered | 4 Replies | 5493 Views | Created by FZB - Friday, February 9, 2018 12:51 PM | Last reply by Hannah Yu - Tuesday, February 13, 2018 3:03 AM -
5 Votes
Limiting index rebuild time
First, an index rebuild can be done online or offline...Answered | 12 Replies | 3100 Views | Created by Joseph Torre - Monday, May 5, 2014 4:09 PM | Last reply by Sean Gallardy - Tuesday, May 6, 2014 12:10 PM -
1 Votes
Rebuild cluster index
If the aim is to remove fragmentation, you need to rebuild the NC indexes as well.Answered | 7 Replies | 1059 Views | Created by Gal1 - Wednesday, January 7, 2015 7:54 PM | Last reply by Alberto Morillo - Thursday, January 8, 2015 1:37 PM -
0 Votes
Index rebuild question
Minimum lock will be held at the beginnging and end stage of index rebuild.Answered | 2 Replies | 1258 Views | Created by sqljoker - Tuesday, April 23, 2013 9:10 AM | Last reply by Srinivasan Ram - Tuesday, April 23, 2013 9:25 AM -
2 Votes
avg_fragmentation_in_percent always high though rebuild index every night
Check T-SQL Tuesday #010: Little Known Index Facts and ...Answered | 6 Replies | 8690 Views | Created by George Zhou - Friday, August 12, 2011 4:05 PM | Last reply by ajaymalloc - Monday, August 15, 2011 9:29 AM
No announcements
