No announcements
Found 936974 threads
-
0 VotesDisk space requirement for Rebuild indexes
Hi Neeraj Space requirement depends how you are rebuilding the index.Answered | 4 Replies | 1803 Views | Created by Neeraj Bhandari (MS SQL DBA) - Thursday, July 9, 2015 8:08 AM | Last reply by Niting123 - Friday, July 10, 2015 7:37 AM
-
0 Votes
Estimation of disk space and time requirement of index rebuild operation.
The time required is completely subjective, and no true method of estimating it is possible.Answered | 1 Replies | 6836 Views | Created by Rushikesh Bakale - Friday, December 18, 2009 5:21 AM | Last reply by Jonathan Kehayias - Friday, December 18, 2009 1:01 PM -
0 Votes
Does rebuilding an index use space availiable from the disk or the data file?
You asked: Does rebuilding an index use space availiable from the disk or the data file?Answered | 4 Replies | 6761 Views | Created by James Ay - Tuesday, January 4, 2011 9:36 AM | Last reply by Kalen Delaney - Tuesday, January 4, 2011 10:34 PM -
1 Votes
How much space is required to rebuild all my indexes in my database?
how to react in such scenario's and what are best practices while rebuild index maintenance plan.Answered | 6 Replies | 13465 Views | Created by Manu_vmr - Wednesday, July 11, 2012 2:56 AM | Last reply by VidhyaSagar - Wednesday, July 11, 2012 10:53 AM -
3 Votes
Rebuilding index
When a nonclustered index is not disabled, the rebuild operation requires enough temporary disk space to store both ...Answered | 3 Replies | 1964 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
index rebuild (free space needed)
Note that if the rebuild is serial (which all scripts known to me are doing), then the free space should be based on the single largest index (including clustered) - not the ...Answered | 7 Replies | 881 Views | Created by Man-Of-Steel - Thursday, September 24, 2015 12:22 AM | Last reply by kranp - Thursday, September 24, 2015 9:41 PM -
0 Votes
Rebuild index
Decide Reorganize or Rebuild Indexes based on fragmentation level.Answered | 5 Replies | 1356 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 -
9 Votes
Log space involved in Index Rebuilding
Because Index rebuild will create a new copy of the index before dropping the old index and for this it needs to allocate space.Answered | 11 Replies | 1015 Views | Created by G Srikar Reddy - Thursday, January 23, 2014 11:02 AM | Last reply by G Srikar Reddy - Friday, January 24, 2014 1:07 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 | 1422 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 -
3 Votes
Estimates freed space after index rebuild
Actually I was under impression free space of the disk but if you talk about it I would say that Fill Factor determines how much (on leaf level) ...Answered | 9 Replies | 1225 Views | Created by Stefano_C - Wednesday, February 12, 2014 1:09 PM | Last reply by Uri Dimant - Thursday, February 13, 2014 6:48 AM -
3 Votes
Rebuild Indexes
So, I am also considering them into the rebuilding of indexes.Answered | 9 Replies | 3841 Views | Created by Ronit Roy - Friday, February 3, 2012 6:46 AM | Last reply by eralper - Tuesday, February 7, 2012 6:23 AM -
1 Votes
Index Rebuild
NO its not required to put DB in single user mode for index rebuild ,I dont know from where you got this ...Answered | 19 Replies | 3778 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 on Standard Edition with explanation?
Addition to above- see here- Disk Space Requirements for Index DDL ...Answered | 2 Replies | 1431 Views | Created by ApolloDB - Thursday, August 15, 2013 6:36 PM | Last reply by Rama Udaya - Friday, August 16, 2013 4:56 AM -
6 Votes
Rebuild Index
It is offline rebuild index.Answered | 7 Replies | 1388 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
Index rebuild question
Minimum lock will be held at the beginnging and end stage of index rebuild.Answered | 2 Replies | 1158 Views | Created by sqljoker - Tuesday, April 23, 2013 9:10 AM | Last reply by Srinivasan Ram - Tuesday, April 23, 2013 9:25 AM -
0 Votes
Why not always rebuild indexes?
if you use a FG, as much as i understand it dosen't solve the defrag problem, beacuse 2 FG files can intersect in the defrag level and will be "mixed" and the same place on disk.Answered | 4 Replies | 4427 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
Data file grows while rebuilding the index
That space requirement is not in tempdb.Answered | 14 Replies | 10283 Views | Created by SQLNDP - Monday, April 25, 2011 8:19 PM | Last reply by John Eisbrener - Wednesday, April 27, 2011 3:48 PM -
0 Votes
Rebuild Index error
Building or rebuilding an index generates a lot of transaction log activity.Answered | 2 Replies | 11221 Views | Created by Mikha - Wednesday, January 6, 2010 3:56 AM | Last reply by Glenn A. Berry - Wednesday, January 6, 2010 6:57 PM -
0 Votes
Rebuild index
This process might take time so immediately you wont see free space, may be tomorrow you would be able to shrink and release space.Answered | 6 Replies | 1716 Views | Created by Sudhakar Vallamsetty - Thursday, June 5, 2014 9:24 PM | Last reply by Uri Dimant - Friday, June 6, 2014 9:06 AM -
2 Votes
Periodic Index Rebuilds - any disadvantages???
Similarly for the amount of free disk space, because completely reindexing a big table requires the same amount of free space (and a bit more).Answered | 7 Replies | 4579 Views | Created by warnerrj79 - Thursday, January 31, 2013 2:47 PM | Last reply by Gert-Jan Strik - Thursday, January 31, 2013 9:27 PM - Items 1 to 20 of 936974 Next ›
No announcements
