Viewing 15 posts - 106 through 120 (of 183 total)
My first view joins 3 tables and has some condition to join them. During the process of the Report I have to join that view with a temp table...
November 18, 2009 at 2:28 pm
Ok. I have my table partitioned by date. An index was patitioned as well.
I actually, partitioned 1 more tables that is joined to this table (Parent-Child relationship).
The Report could improve...
November 11, 2009 at 10:09 am
Thank you. Actually, I applied that to my other table. I partitioned my indexes where the date is used.
Im restructuring my second table. let you know how it goes.
November 10, 2009 at 1:49 pm
This table has around 200millions of records and it has to be part of the Archive Data as well. Partition by Date is the best partition for this table as...
November 10, 2009 at 1:23 pm
this is basically my scenario. This is the kind of queries I use in mostly of my Reports. I'm planning to get a denormalize tables and run a daily process...
November 10, 2009 at 11:18 am
This thread is apparently for another table, I assume in the same DB. That's why I recommended partitioning by date again if possible. Especially to simplify files/filegroups.
Yes, this table...
November 10, 2009 at 10:37 am
Why would you partition on a 20MB file anyway ?
[/quote]
Actually, I made a mistake in the file size. After I created my partition and move the data into that. the...
November 10, 2009 at 7:30 am
this is what I did:
ALTER DATABASE [DATABASE ]ADD FILEGROUP RANGEID
ALTER DATABASE DATABASE
ADD FILE
(
NAME = 'RANGEID'
, FILENAME = 'F:\MSSQL.1\MSSQL\Data\RANGEID.ndf'
, SIZE = 20000 KB
,FILEGROWTH = 10%
) TO FILEGROUP [RANGEID]
CREATE PARTITION FUNCTION...
November 9, 2009 at 4:17 pm
Yes it is the same database. And it has a datetime column. But, this table join only for the ID, we dont do anykind of reports for the date (from...
November 9, 2009 at 1:09 pm
I just checked the range with the people use it. and the range is for over 25 years. So, I dont need partition the whole Range. The Range I need...
November 9, 2009 at 12:45 pm
right now I used bcp.. The next step is to use SSIS instead bcp for the insertion of data.
conclusion: If i restore my full backup, the filesgroups will restored with...
November 9, 2009 at 11:54 am
My DB is 330GB. We don’t need a full model in this case. We just insert data and then we create reports. The reason of the 12 filegroups is because...
November 9, 2009 at 11:47 am
I thought that. I dont want to deal with 1000 files.
What do you think about this?
The range of ID is big and the records only fit the range of one...
November 9, 2009 at 11:38 am
Viewing 15 posts - 106 through 120 (of 183 total)