Have you...

Steve Jones - SSC Editor (10/26/2011)

---

Yes, I think some running total is needed. Something like this: http://www.sqlservercentral.com/articles/T-SQL/68467/

The problem is that you cannot do the division in the same way as...

Kenneth Fisher-475792 (10/26/2011)

---

First let me point out that people trying to help out on this form are shooting blind. We have to start at the beginning and assume nothing....

o you have a fixed number of channels? I don't see a channelId or something to identify which channel is feeding the data. If it is fixed, you can...

So, you have something similar to a running total. Anyone thinking pseudo-cursor and quirky update?

Jared

Do you know offhand what the typical actual length...

Also, if you are just backing up dbs and tlogs, I find a stored proc or script within a job is much easier to maintain versus a package created by...

If all else fails... Recreate the maintenance plan, delete the old one, and reschedule. Sometimes SQL can be quirky 🙂

Jared

So... Once the job is open, you are clicking on schedules, highlighting the schedule, then clicking edit. Schedule type is "recurring" and the enabled box is checked? Then... Occurs Daily...

Are you changing the run times through the maintenance plan or directly through the job? I am asking so I...

Whoa... Can you give me some context or business rules? I don't quite understand what is being multiplied and divided...

Thanks,

Jared

When you say that you set up maintenance plans, I assume you are referring to the wizard?

Jared

I have a stored procedure that moves all of the data from the application tables into a data warehouse table. This is a nightly job, but you can set it...

When SQL Server performs a backup, or any 3rd party does, it does specific things to SQL Server and the mdf file (also the log file). Thinks like checkpoints,...

I just took a...