C:\>osql -L listens TCP/IP and Named Pipes, that is why you may get duplicates in the server list.

Of course when the one of them is disabled you will not...

The author was loking for solution like ALTER JOB..., that is why I sugested a similar way.:-)

A little more details about relation a AWE-mapped memory and SS Edition:

The physical memory accessible by AWE depends system you are using. The following list provides the maximum physical...

Correct.

It is nothing about averhead with AWE. During startup, SQL Server reserves only a small portion of AWE-mapped memory. As additional AWE-mapped memory is required, the operating system dynamically allocates...

There is nothing like ALTER JOB command.

But when you script your job as CREATE TO ... You will have full script, which will recreate a job for you. If you...

Here are a couple a good strategies:

http://weblogs.sqlteam.com/mladenp/archive/2008/05/21/SQL-Server-2005-Immediate-Deadlock-notifications.aspx

http://www.mssqltips.com/tip.asp?tip=1036

Of course you can combine MONTH and YEAR in one column like that:

MONTH_YEAR is (MONTH([DATETIME]) + '-' + YEAR([DATETIME])) AS [Month_Year]

What is the reason to keep a Month and a Year in one column? I am just curious.

It is easy to work if you divide your [DATETIME] as YEAR, MONTH,...

Correct.

According to Microsoft Best Practices one SAN disk is Ok to keep all you TempDB datafiles.

Ok.

I would put TempDB log file on a separate drive with size around 10 Gb and restrict the file grow at 9Gb. In this case you will have extra 1Gb...

I need to get more details before I give you any recommendations.

Does server have 16 physical CPUs or it 8 dual cores?

What size of a SAN disk is going...

It depends.

In general this migration should be even more smooth than migration from SS2000 to SS2005, especially if you leave your database in compatibility level 80.:-)

But you can find some...

Yes, It sounds like tempdb issue.

In this case it is also good idea...

Elliott is correct.

But I was correct too in my diagnosis.

SQL Server can run SSIS packages regardless of edition and using just the Database Services' DTEXEC.exe executable for that....

As George said, the answering the question 1) is a big subject with many options.

But you were asking about guide.

So, the brief and a general guide is here. Remember, it...