Set the recovery mode to SIMPLE or Bulk Logged... use SELECT INTO to make the tables and transfer the data. Then, add indexes, keys, triggers, and constraints... use NOCHECK...

It's the number of seconds since 1970-01-01 and can be changed to an SQL Server DATETIME datatype using something like the following...

SELECT DATEADD(ss,1195507770,'1970-01-01')

You also have many columns being returned in the SELECT lists of the derived tables that aren't used anywhere else... remove them. Just return enough data in those derived...

Doing a convert on a column guarantees there's no chance of an index being used as effectively as it could... you need to change this...

AND (convert(VARCHAR(6), TT.StartTime, 112)= '{?Period}')

......

Ummm, dates cannot be blank... so doing this...

AND (ISNULL(update_date, '') <> ''

... is a total waste of CPU clock cycles. Further, putting ISNULL on the date column will...

Absolutely not a problem, Ben. Thanks for the feedback.

TheSQLGuru (6/24/2008)

---

DTA is like any other tool: if you KNOW how it works and how to use it it can be an effective device. But I have had...

And... you might just want to learn to use Float for financial calculations and then round the answer to make the humans happy. A great many of the functions...

Heh... Decimal is prone to more "rounding" errors than Float ever will be... it's a matter of rounding to the correct scale... For example, what should the answer to 1/3*3...

You can use a similar method in 2k, but you'll need to insert into a temporary table that has an IDENTITY column so that you get sequential numbers.

What you're looking...

Yep... suggestion is that you post the code that has the problem insert so we can see what you're actually doing and post the text from the actual error so...

I agree with Stephanie... you really need to find out both the what and the why... if they intend to use only numerics with leading zero's ... forever... then store...

Sound like you've got a pretty good plan...

Deleting from last month is easy... Let's change the definition just a bit to make this even more simple... you want to...

I'd try to help... but I can't even spell SSRS, yet. Sorry...

Manie... what's the page link to get to that download?