Look at books Online for Pivot table

Backing up the TLog is suppose get rida of the Usage if appropriately times.

Thomas

There is no Right-Click report to show you the history.

There was probably a Log Backup between the alert and the time you ran the report.

You could setup a job to...

Do you have a clustered index on the table?

Thomas

Can you post the Creaste Table for the tale(s) you are talking about?

And the 2 different queries?

Try to get a Show Execution Plan (Estimated and Actual) and look for...

You should definitely look into 2 areas:

1. Table Partioning. This will let you import the data into a partion (by date), then combined with existing data.

2. Bulk-Insert - minimum logging...

Excellent summary and I agree with it all.

You should do articles on each individual point with examples.

Thanks,

Thomas LeBlanc

TheSmilingDBA

Thanks for the series Bill.

Thanks,

Thomas LeBlanc

TheSmilingDBA

!Dir does not work, it has to be !!Dir

Thanks for writing this series, as apparent with all the responces, there is a lake of this knowledge in the development world.

I was once like some of these respondees...

Thanks for the details in the article, I am gald I read through the whole article and comments The comments helped the discussion topic and paths to loading a Data...

Number 2 is you have time for maintenance at night. No blocking, but it is resource intensive.

We have a job the loops thru a table with the day of the...

Good article, needed to know a little about SSIS while following example.

Thanks,

Thomas

Thanks Tim. Followed this article step by step with no problem.

Thomas

Totally agree with Hugo...Our database standards doc says to make sure you have a Natural Business Key (Unique Constraint) on all tables. This is what identifies the day.

Hugo,

Thanks for the...