Depending on how much data will be left in your table (I did this once to delete 14 mill and be left with 1 mil records and it worked nicely)....

Why not New Zealand? I went this time last year. Its their spring, go to http://www.skyauctions.com I picked up tickets for $600 RT from LA to Auckland. Hop a...

If you open Enterprise manager then open your sql server, then go to management, then right click on SQL Server Agent and select properties. On the properties page, click on...

I assume your asking how to recover the box, not how to create a plan? Can you tell what has failed? Do you get to the bios when it boots?...

You should definitly be using Analysis Services. Then you can have a multitude of choices. I use the free thin web client see it at http://www.utcodes.org/queryabledata/cube/analyzer/default.asp  - it requires...

I've been running my db's on a Hitachi SAN for about 2 yrs and have had 2 corruptions, the first caused by 1 disk failing and the controller failing to...

Are your databases corrupt or your disks?

If you disks are corrupt, it could be your controller (I assume this is a SAN?) ... I agree contact EMC if this is...

In enterprise manager you can assign 1 cpu for SQL server, the other would need to stay unchecked. At least this is my understanding of the license.

You also need to look out for Academic Bundles. Acedemia has its advantages especially in pricing - but if you don't qualify, your out of luck. http://www.cdw.com or

I fear you will have problems with this system down the line, you should do some hardware diags on it and see if there isn't a raid controller issue, or...

I have had this before with a bad CD. Do you have another copy of the media?

If you want your reports on the web, I highy recommend the olap thin web client from the SQL server 2000 resource kit or download from http://groups.msn.com/OLAPServicesDevelopersForum/web.msnw?action=get_message&mview=1&ID_Message=45

I have an...

I've have worked with lots of systems that utilize the 1 table approach to lookups. And my opinion is that they should never, ever be used. Imagine making a datawarehouse...

These are never fun in any SQL environment. Using a reporting tool, like reporting services, or crystal reports can do this easliy. But if your stuck with TSQL you could...

I think short sighted is probably the best term I can think of. Raid the coffers, spend without taxing ... As long as were currently ok who cares about the...