SQL Server Performance Forum – Threads Archive

How to expand table in SQL

Hi is there a possibility to do that.
Or i can only exted the file group on which table located?

Tables are expanded automatically. File group too.
Or I missing something in your question. Luis Martin
Moderator
SQL-Server-Performance.com

My question is: can I expand individual table ,but not whole database The autogrow on my db is disabled

You can’t expand individual table. You have to enable autogrow or increase manually filegroup.
Luis Martin
Moderator
SQL-Server-Performance.com

Agree to LuisMartin.
table expand automatically,if your table’s file group is large enough. a lonely man

The auto_grow is by file, not by database. If you create another file, putting it in it’s own filegroup, and put the table and corresponding indexes in that file, you can have autogrow on just that particular file. Is this what you are looking for? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

As soon as all the files in a filegroup are full, SQL Server automatically expands one file at a time in a round-robin fashion to accommodate more data (provided that the database is set to grow automatically). Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Okey that is what i thought .
I was told that previously they extended table only not a database.
So I was confused by that.
But what they probably meant that table was on different file.
And this file they actually extended

True in case the tables are divided into different filegroups. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>