Question : By chance, I happened to see that the autoclose feature on SQL dbs (I’m using SQL 2008) shouldn’t […]
Tag: database-size
SQL Database size incorrect and database file growing while empty
Question : RESOLVED – SOLUTION AT BOTTOM OF POST PROBLEM I have a database data file showing as 200GB on […]
Database schema size result differs from file size when exported
Question : I used this query to find out my database size SELECT table_schema “Data Base Name”, sum( data_length + […]
Finding integer database columns that may have their data type changed to reduce size
Question : I have a database schema that I’ve inherited where all the integer columns have been defined as int […]
My database dramatically increased in size. Why?
Question : I found that my database, specifically the USERS tablespace, dramatically increased in size. How can I find what […]
How many blocks is my database
Question : How can I write a query using Oracle SQL Developer to find how many blocks my database is […]
postgresql logical replication — subscriber size discrepancy
Question : I have a postgres 11 database in Amazon RDS with a little over 2 TB data in it […]
Estimate a Database Size
Question : I have to do some project and need to estimate the DB size. I’m going to use Oracle […]
Are junction tables a good practice?
Question : Say I have a large table that holds the user’s info and another table that holds several locations. […]
Can the number of tables and functions affect performance? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]