I'd opt for W2K3 SP1 first (since you have to do both) ... logically speaking the Windows OS came before SQL Server in installation order on the server did it not...

I would not bother with the SQL dump files (or mini-dumps). If your Windows Admins are correct, then a cluster configuration issue is pretty easy to fix in an active/active...

Steve, we've used MOM 2k and have been using MOM2K5 for some time now. Running in parallel seems logical for an upgrade of this sort for an enterprise. We did...

Have you tried executing sp_who/sp_who2 in QA when the one database on the server 'freezes' ? You may have blocking issues.  Also have you tried executing sp_lock as well ?

Most shops I have been at that did development work named the databases the same. Each type of database (dev/test/qa/prod/prodfix) had it's own instance. The downside is that an inexprienced...

Have you contacted MS to find out if there is a fix/workaround for installing on a named instance ?

It's still great information for those who care Steve. Maybe I'm too close to the issue - being a former 'White Hat' from the early days ... Oh well have...

Interesting ... I thought this editorial would have generated quite a response - boy was I mistaken. However I feel that the majority of the 'issues' are MS own fault...

Late as well here ...

I believe that it has to do with the default directory and the lack of PATH information. First you need to determine where you are exeuting from then what PATH...

One additional point about blocksize. A blockize of 8 kb will make more efficient use of your existing disk reaources for storage than a 64 kb blocksize. This is because...

Just a clarification on SQL Server I/O operations ...

SQL reads in extents - 64 kb blocks or 8 pages

SQL writes pages - 8 kb

What is the salary range ? Will they provide relocation assistance ?

It's great that the tools will support this. However that is not enough. The biggest paradigm change must occur in the organizations that use these tools and platforms. In other...

We are running SQL 2K SP3a hotfix 818 on Win2K SP4 server and Win2K3 server SP1. Our upgrades from Win2K SP4 to Win2K3 SP1 were smooth with no issues. Also...