Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scazikiss
Starting Member
12 Posts |
 Posted - 2013-04-19 : 09:25:14
|
| hello, i would like to reorganise the tables.what is the best way to do that..? the goal is just for decreasing the tables size. thanks for your reply. regard.regard |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-04-19 : 10:07:47
|
| Can you show a simple example of what you mean by reorganizing?I don't think reorganizing a table would decrease the size of that table. If you have a certain amount of data in the table, no matter how you organize it, it is going to take up a certain amount of space. You can normalize the tables if there is unnormalized data, and that may decrease the space usage - but that will also change the schema, resulting in any queries that depended on the original schema to break. Also, you may be able to define some columns as sparse columns if they are sparsely populated, but it doesn't seem like any of that is what you are looking for. |
 |
|
|
|
|
|
tables reorganisation