Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Quick question about reindexing 1

Status
Not open for further replies.
vnad

vnad

MIS
Nov 22, 2002
91
US
Does reindexing a table need as much free space as the table takes up? We have a 70 gig table and was wondering if we would need 140 gigs to reindex the clustered index.

Thanks
 
Sort by date Sort by votes
Just covered that in ms's programming sql server2000 class today. You need and additional 1.2 times the size of the file. you should have atlease 154gig.

hth

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
SSMS question 1
Replies
4
Views
1K
Sana Shazadi
S
Andrzejek
  • Locked
  • Question
Field types question
Replies
9
Views
649
Chris Miller
Chris Miller
ahmedsa2018
  • Locked
  • Question
the goal mfrom asking question is t
Replies
0
Views
245
ahmedsa2018
ahmedsa2018
Andrzejek
  • Locked
  • Question
Management Studio behavior question 1
Replies
3
Views
399
MarkSweetland
MarkSweetland
Uprightguy
  • Locked
  • Question
Query Question 2
Replies
4
Views
388
Uprightguy
Uprightguy

Part and Inventory Search

Sponsor

Back
Top