Database Space Concerns

Database
Enthusiast

Database Space Concerns

I am trying to create a new table in one of the databases and the free space for that database is ~300 GB. But I get an error message as "No more room in databasename". The new table is just ~15 GB in size.

Can any1 help me with the same..thanks..

2 REPLIES
Supporter

Re: Database Space Concerns

Did you specify the primary index? If not the first column is used by default.

Most likely that there is a skew issue.

If not check that the existsing tables in this database doesn't have huge skew.

Supporter

Re: Database Space Concerns