Using Management Studio logged on to the server.

dbcc shrinkfile (TLOG)

Any thing else just ask.

Sergiy (8/30/2010)

---

What you need is a clusted index on [DW_PROD].[dbo].[SPF053_SALES] (dwyear, dwweek, dw_dow, dwstore)

Then your query will return results instantly.

But schedule index creation for weekend: on a table with 900...

According to an article I read on parameter sniffing I see that the first time the procedure is run if the...

I appreciate the help, all. The problem is fixed.

Thanks

As you can see, if the @Param_Year is null the default values, which are the current date - 1 day, captured earlier in the procedure are loaded into the params...

Thanks a lot. I'll look up parameter sniffing. And yes the table has over 900,000,000 rows.

The rest of the procedure:

SELECT DWSTORE

,@Param_Year as Param_Year

,@Param_Week as Param_Week

,@Param_DOW as Param_DOW

, sum (dw_sales_units) as [Total Units]

...

No indexes on Sword_Calendar (ought to be one on Greg_Date) but there is less than 10,000 records (rows - I'm an old mainframe programmer) in the table.

I agree with your...

I guess I'm just too impatient. I can't take the time to go through a 500 page book, even the first 200 pages, just to learn how to do...

Generally when programs are removed there are residual folders, data, etc. left on the machine. Poor maintenance routines by the package authors. You will have to go to...

Ah ha!

Under forced execution value:

ForcedExecutionValue = 0

ForcedExecutionValueType = Int32

ForceExecutionValue = False

Under Execution:

FailPackageOnFailure = False

FailParentOnFailure = False

MaximumErrorCount = 1

I think you have struck on something here. Shouldn't the FailPackageOnFailure be...

With all you have tried and the length of time you have taken, it might be the best advise is to uninstall sql and reinstall it from the original discs....

As you proceed through the installation you will come to a panel where you are shown the various items in SQL with an indication they are installed or partially installed....

You should not have to uninstall SQL before reinstalling it. Go to add programs and start the process from that screen.

When a line of code fails, the remainder of the code is not executed. That line is the same in all ActiveX scripts. If I tested for the...