Viewing 9 posts - 1 through 9 (of 9 total)
I will try to backup and restore this db.
Lets see if this will work.
January 14, 2015 at 4:43 am
ScottPletcher (12/26/2014)
To be sure, make SQL update the page (and row) usage counts and see if there are any large discrepancies:
DBCC UPDATEUSAGE ( '<your_db_name>' )
I did this, the pages were...
January 14, 2015 at 4:39 am
M. Gamito (12/12/2014)
Jeff Moden (12/11/2014)
M. Gamito (12/11/2014)
Jeff Moden (12/11/2014)
M. Gamito (12/11/2014)
I'm having some problems with my database usage space.
I have a database with atogrowth off and limited size to 150GB.
When...
December 15, 2014 at 9:09 am
Jeff Moden (12/11/2014)
M. Gamito (12/11/2014)
Jeff Moden (12/11/2014)
M. Gamito (12/11/2014)
I'm having some problems with my database usage space.
I have a database with atogrowth off and limited size to 150GB.
When users try...
December 12, 2014 at 6:28 am
DBA From The Cold (12/11/2014)
CREATE TABLE #TableSize
([Name]VARCHAR(255),
[rows]INT,
[Reserved]VARCHAR(255),
[Data]VARCHAR(255),
[Index Size]VARCHAR(255),
[Unused]VARCHAR(255));
CREATE TABLE #ConvertedSizes
([Name]VARCHAR(255),
[Rows]INT,
[Reserved (KB)]INT,
[Data (KB)]INT,
[Index Size (KB)]INT,
...
December 11, 2014 at 9:13 am
Jeff Moden (12/11/2014)
M. Gamito (12/11/2014)
I'm having some problems with my database usage space.
I have a database with atogrowth off and limited size to 150GB.
When users try to import files, large...
December 11, 2014 at 9:10 am
DBA From The Cold (12/11/2014)
Hmm, I'm wondering if the free space is actually free space within existing objects. Does the database have data bulk inserted and then removed often?
This database...
December 11, 2014 at 9:08 am
DBA From The Cold (12/11/2014)
Is there only the one filegroup (PRIMARY) in the database?
Yes.
Just "PRIMARY" and log.
December 11, 2014 at 7:01 am
Viewing 9 posts - 1 through 9 (of 9 total)