No announcements
Found 1420465 threads
-
1 VotesThe fastest way to rebuild indexes
Hi zhichkin, The fastest possible way to rebuild indexes is to rebuild the indexes in OFFLINE mode because ...Answered | 3 Replies | 3473 Views | Created by zhichkin - Wednesday, June 17, 2015 1:49 PM | Last reply by zhichkin - Thursday, June 18, 2015 7:39 AM
-
1 Votes
Index Rebuild
Please suggest me better way to do it.Answered | 19 Replies | 4001 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
Index Rebuild
Is there any way to minimize log file growth while index rebuild?Answered | 4 Replies | 1079 Views | Created by PraveenKumar_1999 - Monday, June 20, 2016 2:28 PM | Last reply by Shanky_621 - Tuesday, June 21, 2016 7:29 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 | 6813 Views | Created by Samantha v - Friday, September 19, 2014 12:38 PM | Last reply by Ashwin Menon - Friday, September 19, 2014 12:56 PM -
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 | 1543 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 -
0 Votes
Index Rebuild on SQL Server 2016
Here is a step by step guide for rebuilding Index In SQL ServerAnswered | 3 Replies | 1541 Views | Created by VijayKSQL - Sunday, November 12, 2017 7:22 PM | Last reply by Robin Shanab - Monday, November 13, 2017 5:29 AM -
3 Votes
Rebuild Indexes
So, I am also considering them into the rebuilding of indexes.Answered | 9 Replies | 4000 Views | Created by Ronit Roy - Friday, February 3, 2012 6:46 AM | Last reply by eralper - Tuesday, February 7, 2012 6:23 AM -
3 Votes
Rebuilding index
Hi, What happens to tempdb when we rebuild the index in online?Answered | 3 Replies | 2071 Views | Created by Surya.chamala - Saturday, August 31, 2013 8:48 PM | Last reply by Sarat (SS) - Sunday, September 1, 2013 5:24 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 | 5758 Views | Created by neophytenik - Monday, May 18, 2009 4:20 PM | Last reply by neophytenik - Monday, May 18, 2009 6:45 PM -
6 Votes
Rebuild Index
It is offline rebuild index.Answered | 7 Replies | 1555 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
Rebuilding index
Hello , Are you talking about Online index rebuild?Answered | 1 Replies | 1773 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
Rebuild index
Decide Reorganize or Rebuild Indexes based on fragmentation level.Answered | 5 Replies | 1474 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's
when you rebuild index, stats that are linked to the index also get updated.Answered | 7 Replies | 5487 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 | 5134 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 | 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
rebuilding 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 -
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 -
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
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 | 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
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 - Items 1 to 20 of 1420465 Next ›
No announcements
