|
Home > Archive > MS SQL Server Clustering > January 2006 > Non Clustered Effect
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Non Clustered Effect
|
|
| Travis 2006-01-11, 3:23 am |
| Hi ,
When I finish to create one non clustering index on of of my table , I
found out that the size of the hard disk increase amazingly.
I decide to drop the this index but the hard disk size did not back to
original size before that. What should I do next ? Please help
--
Travis Tan
| |
| Luca Bianchi 2006-01-11, 7:23 am |
| Travis wrote:
> Hi ,
>
> When I finish to create one non clustering index on of of my table
> , I found out that the size of the hard disk increase amazingly.
>
> I decide to drop the this index but the hard disk size did not back
> to original size before that. What should I do next ? Please help
It's possible to configure automatic grow for database files and in this
way, when a db need space for an object (table or index) it take from os. If
you delete an object the space previously allocated won't be shrunk (unless
you set auto_shrink option but it's better to avoid this).
You may use DBCC SHRINKDATABASE or, better, DBCC SHRINKFILE to reduce the
space used by a database. See BOL for more details and for sintax of DBCC
commands.
Bye
PS: "clustering" in the name of this newsgroup means "Clustering technology"
and not as clustered (or not clustered) index...
--
Luca Bianchi
Microsoft MVP - SQL Server
http://mvp.support.microsoft.com
|
|
|
|
|