Very Funny

Who says MS guys don't have a sense of humor.

Thanks Steve

I have to ask why the downgrade ?

I doubt if MS will give you a refund.  If you are moving this license to another server OK.

I would have to reread...

I would check Compaq(HP)s website, They used to have a very good whitepaper on RAID and SQL Server.  Although if it is still there it is getting old, but much...

Web access requires Per Processor, as CALs would be needed for each user, not concurrent user.

No sure if an IntrAnet website would still require per processor, but a web facing...

I have used EM to do this regularly, and even on Prod boxes.  But definitely OFF hours.

Since there is no data in the table an alternative also would be to script...

Can't use CAL licensing when accessing from a Website (or MTS I believe) must be Proc for these purposes

There is also a downloadable systable.chm version of the system table map. 

Don't remember where I got it, I assume off of MS somewhere.

First Pedro that was a great link on HT, so it basically allows the processor to be more efficient.  Somewhat like multiprocessing allows the machine to use more processor, HT...

I would think the LNU concept would create a hotspot on the LNU table.

How about inserting via a SP, and store the Next key in a global or a temp...

We generally saw improvements, not necessarily enough to write home about, but 5 to 10 %.

So far Win2003 is proving to be a screamer. Testing is still early, and we...

I'll agree with Steve on the Clustered indexes. I personally have a rule, rules are made to be broken though, that every table had a clustered index.

Never make the...

I'll chime in FOR the Maintenance Plans, but there are issue's.

The first, and most common is you have to understand what the wizard is doing under the covers....

As I understand it, the software is free you can install it everywhere. BUT you need a license to access the server, either a CAL or a per CPU...

The newer intel chips, support HT or hyperthreading technology. Which basically puts 2 processors on a single piece of silicon. It's not a true dual, they share cache...

We did some testing quite a while back, I think it was a pre production compaq with HT. It did work well, don't expect 2 to one, of even...