Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: May 2011

An Update To My Previous Post

I have picked Row compression and moved it out of [Primary] and into its own FileGroup and .NDF file.  I’ve been monitoring it this week and it’s been looking good so far.  *Knock on wood* 

I have started on another large table and have chosen Row compression due to constant… Read more

0 comments, 270 reads

Posted in James' SQL Blog on 13 May 2011

My Partitioning And Compression Quest! (Continued)

Thank you, David C, for your comment!  Please see below to the answers to your questions.

The table structure is:

CREATE TABLE [dbo].[Table_NoChange] (
    [ID] INT NOT NULL,
    [Time] SMALLDATETIME NOT NULL,
    [Currency] SMALLMONEY,
    [Flag] SMALLINT,
    [Currency_Max] SMALLMONEY,
    [Note] VARCHAR(500))

There is only one… Read more

4 comments, 432 reads

Posted in James' SQL Blog on 5 May 2011

My Partitioning And Compression Quest!

So I have a pretty big database (around 1 TB) that’s getting a bit out of hand.  I inherited it and have been doing things to improve it ever since I started this new job.  And boy, there’s been some changes since I first started.  Let’s just say that this… Read more

1 comments, 308 reads

Posted in James' SQL Blog on 3 May 2011