I had a large number of deletes and did something similar to previous posts. I used a loop to delete in smaller groups, with a waitfor. I also made a...

I did in place upgrades from 2000 to 2005 without problems, but I'm pretty sure I was on the most recent 2000 service pack first. I don't know if it...

John Mitchell-245523 (3/1/2012)

---

I think a Dates table would come in very handy here. You can create one something like this:

WITH Numbers(N) AS (

SELECT

ROW_NUMBER() OVER (ORDER BY c1.name)

FROM

master.sys.columns c1

CROSS JOIN

master.sys.columns...

Bump for solution added to original post.

pdanes (2/10/2012)

---

Yay! I'm almost completely out to lunch on the subject of backups. I've been doing a...

The advantage of Backup/Restore is it will automatically include any new tables that get added to the database in the future.

If it's going to a different server then you may...

So, if you have 3 records with key values of 1, 2, 3. Then you try to change the 3 to a 1, you are attempting to create a duplicate...

Can you start the scheduled job manually ?

What sort of performance problems did you find, and how did you fix them ?

Perhaps there is more tuning that can be done. Even though current performance is acceptable, there...

I run a server side trace, and Idera Compliance Manager to log events.

Transfer Task is where I would expect it, but I don't see much understandable info in there.

Pretty sure that answer is no. I only see a log of events, but not very useful.

Why no index on time_occurred ?

Is the table getting bigger, so that originally a table scan was quick, but now takes much longer ?

So you have it scheduled for a specific time (eg 6:00 am), but it never runs or fails ?

Does the job run manually ? Or the DTS by itself...

I used a 3rd party free tool to import all the DTS packages from 2000 to 2005 (http://www.sqldts.com/242.aspx). It worked perfectly with just about 3 mouse clicks total. Not sure...