Question : I would like to know how to calculate the distribution of data consumed per file in a filegroup, […]
Tag: disk-space
PRIMARY’ filegroup is full [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
DB2 Indexes are taking very large size on disk space
Question : I have huge table in DB with estimated size 7 GB (I saw that using DB2CC and did […]
How do completely empty columns in a large table affect performance?
Question : I have 400 million rows in a Postgres db, and the table has 18 columns: id serial NOT […]
PostgreSQL: Query for location of global tablespace?
Question : I have been trying to make our database clients pro-active about not filling up the partition on which […]
Is DBCC SHOWFILESTATS an accurate way to see unused space?
Question : We have a few tables each with near 100 million rows of data. A co-worker has these tables […]
Does a numeric field always use the same disk space?
Question : When you have a numeric field in MySQL(MYISAM) (E.g. Integer) will it always use the same disk space, […]
How does SQL Server reuse reserved pages after deleting a table
Question : I just want to know: How SQL Server reuses reserved space after dropping a 1GB table? (call the […]
what is the best practice for tempdb autogrowth?
Question : I have a client’s server with about 15 databases on this instance with a data total of about […]
Analyse and report disk usage growth historically
Question : Is it possible to use historic information to show disk usage growth? I haven’t keep much in the […]