sql2k sp3
Before I start, let me assure you that the 5 gigs of free
space in my db is in the data file, not the log file. I
already shrunk the 7 gig log file with no problem. Now
when I run dbcc shrinkfile(db_data_file) it runs for a
long time and then barely shrinks anything. Am I missing
something here? Any ideas?
Thanks in advance.Chris,
You may need to check for fragmentation.Refer DBCC SHOWCONTIG, DBCC
INDEXDEFRAG in BooksOnLine.
Also, may be..
PRB: DBCC SHRINKFILE and SHRINKDATABASE Commands May Not Work Because of
Sparsely Populated Text, Ntext, or Image Columns
http://support.microsoft.com/default.aspx?scid=kb;en-us;324432
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"chris" <chrisr@.fingps.com> wrote in message
news:3bbe01c37626$d832d270$a301280a@.phx.gbl...
> sql2k sp3
> Before I start, let me assure you that the 5 gigs of free
> space in my db is in the data file, not the log file. I
> already shrunk the 7 gig log file with no problem. Now
> when I run dbcc shrinkfile(db_data_file) it runs for a
> long time and then barely shrinks anything. Am I missing
> something here? Any ideas?
> Thanks in advance.
>|||If you want to see where your data is allocated through the data file go to
www.sqlfe.com. You can see what is at the end of the data file.
--
Barry McAuslin
support@.sqlfe.com
http://www.sqlfe.com
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:%23PZlOfidDHA.828@.TK2MSFTNGP11.phx.gbl...
> Chris,
> You may need to check for fragmentation.Refer DBCC SHOWCONTIG, DBCC
> INDEXDEFRAG in BooksOnLine.
> Also, may be..
> PRB: DBCC SHRINKFILE and SHRINKDATABASE Commands May Not Work Because of
> Sparsely Populated Text, Ntext, or Image Columns
> http://support.microsoft.com/default.aspx?scid=kb;en-us;324432
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "chris" <chrisr@.fingps.com> wrote in message
> news:3bbe01c37626$d832d270$a301280a@.phx.gbl...
> > sql2k sp3
> >
> > Before I start, let me assure you that the 5 gigs of free
> > space in my db is in the data file, not the log file. I
> > already shrunk the 7 gig log file with no problem. Now
> > when I run dbcc shrinkfile(db_data_file) it runs for a
> > long time and then barely shrinks anything. Am I missing
> > something here? Any ideas?
> > Thanks in advance.
> >
> >
>
Showing posts with label shrunk. Show all posts
Showing posts with label shrunk. Show all posts
Sunday, March 25, 2012
Sunday, February 12, 2012
Cant hide static groups in matrix
I need to make use of static groups for a matrix however I dont want these to
display in the end result. I have hidden them and shrunk them as much as
possible but they still show - even if I put 0 in for the height it comes
back with .03125 in the height of the cell ... it wont allow 0 (in either
height or width). I cant get the same result if I dont add the rows (which
show up as a static group).Here is more info:
I have something like the following set up: Column is Metric Name , Rows
are Level1_Res and Res Name
The intersect is Value and all the other fields are things I need to keep
track of at the Row or Column level.
For each group. Only the Level1_Res level grouping will show at the end
| |
| Metric Name
Level1_ResName | Res Name | Value | value of field
on DB DB | | Rating vs Thres
| set to 1 if threshold is
| | Threshold Level |
MAX(Fields!RVT.Value)
| | MaxEvents
| some expression
All rows except the first are static row groups and I donâ't want to show them
But they are needed for calculations/expressions for other settings I need.
The problem is that column one is taking the height of the entire grouping
(not just the Level1_ResName but all the static rows too) even tho I shrink
them and hide them â?¦ it doesnâ't let me have a height of zero. It is messing
up my matrix â?¦ not to mention when I export to excel *nothing* is hidden
there! And it should be.
"MJT" wrote:
> I need to make use of static groups for a matrix however I dont want these to
> display in the end result. I have hidden them and shrunk them as much as
> possible but they still show - even if I put 0 in for the height it comes
> back with .03125 in the height of the cell ... it wont allow 0 (in either
> height or width). I cant get the same result if I dont add the rows (which
> show up as a static group).
display in the end result. I have hidden them and shrunk them as much as
possible but they still show - even if I put 0 in for the height it comes
back with .03125 in the height of the cell ... it wont allow 0 (in either
height or width). I cant get the same result if I dont add the rows (which
show up as a static group).Here is more info:
I have something like the following set up: Column is Metric Name , Rows
are Level1_Res and Res Name
The intersect is Value and all the other fields are things I need to keep
track of at the Row or Column level.
For each group. Only the Level1_Res level grouping will show at the end
| |
| Metric Name
Level1_ResName | Res Name | Value | value of field
on DB DB | | Rating vs Thres
| set to 1 if threshold is
| | Threshold Level |
MAX(Fields!RVT.Value)
| | MaxEvents
| some expression
All rows except the first are static row groups and I donâ't want to show them
But they are needed for calculations/expressions for other settings I need.
The problem is that column one is taking the height of the entire grouping
(not just the Level1_ResName but all the static rows too) even tho I shrink
them and hide them â?¦ it doesnâ't let me have a height of zero. It is messing
up my matrix â?¦ not to mention when I export to excel *nothing* is hidden
there! And it should be.
"MJT" wrote:
> I need to make use of static groups for a matrix however I dont want these to
> display in the end result. I have hidden them and shrunk them as much as
> possible but they still show - even if I put 0 in for the height it comes
> back with .03125 in the height of the cell ... it wont allow 0 (in either
> height or width). I cant get the same result if I dont add the rows (which
> show up as a static group).
Subscribe to:
Posts (Atom)