First what is prompting the need for the upgrade? Unless the Enterprise edition has some feature lacking in the Standard Edition (Partitioning, Indexed Views, etc) that you require or...

Usually installing 2005 after 2000 does not cause problems, however installing 2000 (or just the tools) after 2005 has been installed is known to create problems "sometimes". Recommend trying...

/*

I'm not sure I really understood what you were trying to do but let me take a guess and see if

I can point you in the right direction.

*/

--Lets assume you...

Not sure what you mean by "Step by Step". Each situation is unique.

In the event of a server crash then more than one database is involved and...

Site looks great. Kudo's to everyone involved. I had about a day learning curve to get comfortable with where things are and how they work.

Ref the Posted Time...

The most likely culprit is the internal location of the data files which still point to their original location. If the instance you backed up from is still running...

There is probably an easier way to do this but just off the top of my head this would work:

select

case when abs(datediff(second, (select max(somedate) from dbo.jbmtest where somedate <=...

Based on the information provided I don't see any reason not to have the [PartListId] column in the table and allow it to be null since it is not always...

While 28 million records is a large table I've seen larger.  Not knowing your enviornment means most advise you get will be fairly generic.  But some things to consider:

1. Review...

I wasn't criticizing, it was a neat solution.  I have now run all three methods against two tables with 1,000,000 records of random data in each table in a single...

Trying to follow the logic in my head just made it hurt, so I did it in Management Studio.  I then compared the actual execution plans agains ten rows of...

Oops! sorry didn't pay attention to the where clause.  Joins are better then sub-selects under most circumstances.  Thats what I get for not...

Actually the left join will return all the rows that have matching records in the second table, not the missing records.  You pretty much have to go with the not...

Yes the trigger executes within the transaction of the original insert, so any error that prevents the "Commit" statement from running results in all work being rolledback.

You can easily test...

Oops!  You do need to check for the non-zero value otherwise you end up over writting that value with a +1.  add the following where clause to the insert into...