Tagged Questions
1
vote
2answers
86 views
Database running out of space
My database has 16MB of space left.
I used to just truncate as I was taught but I found these links that advise against truncating:
...
2
votes
3answers
1k views
T-SQL query to report disk space allocation and used space for auto-grow SAN databases
We are using 6 databases in total for an application, and we can only share 4TB of space for all 6 databases (via SAN storage). I'd like to write a query (report) for a single database indicating the ...
1
vote
1answer
150 views
Diskspace usage of DB
I have a production database that's consuming a significant amount more disk space than it should be.
Using sp_spaceused (only the interesting tables), I get.
Table Name Reserved (KBs) Data ...
1
vote
1answer
448 views
SQL-Server: sp_spaceused gives zero rows but big dataSize for cleaned table
After cleaning my table with DELETE FROM MyTable (and executing DBCC shrinkdatabase('MyDB') should that matter) I run the statement EXEC sp_spaceused MyTable. The results confuse me:
tableName ...
9
votes
5answers
409 views
SQL Server Backups - A couple of questions
We run our weekly backup job at 9pm on Fridays and we are experiencing a couple of issues with regard to disk space (which gets perilously low at times) and performance. We're looking at ...
10
votes
3answers
987 views
Why might a table's data space take up 4x the size of the raw data?
I have a table with 490 M rows and 55 GB of table space, so about 167 bytes per row. The table has three columns: a VARCHAR(100), a DATETIME2(0), and a SMALLINT. The average length of the text in ...
4
votes
4answers
2k views
Empty strings in VARCHAR(MAX) consuming space which cannot be recovered
I have a table with a non-nullable VARCHAR(MAX) column where every row contains an empty string (third party database so I can't change it). I see a huge amount of space use, over 15GB for 1 million ...
