Tagged Questions
1
vote
4answers
94 views
Shrinking the log file does not reduce size
I have a database which had mdf size of 350 MB and ldf size 4.9 GB
When i try to shrink the log file it's not shrinking. I know shrinking a database is not good and it should not be done. But still i ...
0
votes
1answer
107 views
SQL Server Table keeps big after schema change
I have a table in SQL Server 2012 with 460.000 rows.
This Table has the following Schema:
We had an issue with our application so all 500.000 rows were created with Comments filled up with spaces.
...
3
votes
1answer
202 views
Performance effects of database file size and available space
I have set the autogrowth and maxsize properties to:
By 10 MB, Unlimited
When I look at the Properties -> General Tab by right-clicking the database in SSMS, I see the file size is 2249MB with 6.1 ...
6
votes
3answers
316 views
PostgreSQL Initial Database Size
There are 2 parts to my question.
Is there a way of specifying the initial size of a database in PostgreSQL?
If there isn't, how do you deal with fragmentation when the database grows over time?
...
