The Upgrade Advisor is exactly what told me of the problems that would need to be corrected in advance. Our vendor appears to be useless...

I would say people choose SQL Server over other databases because it is more widely supported than others. Take DB2 and Oracle for example. Searching for help for either of...

I'm currently working on a 2000 to 2005 conversion myself. The biggest thing I have found is that the stored procedures that the vendor wrote do not fully adhere to...

I think the thing we need to remember here is that a database server that is running your Enterprise is not in the same class with Office or Windows. For...

Or, to be just a little more dramatic, detach the database. One of the options is to drop all connections. Then, you can simply re-attach the database.

A simple query consists, generally, of six items:

1. SELECT columns

2. FROM

3. JOIN types

4. ON

5. WHERE

6. ORDER BY

However, it does not process the query in this order. The query is actually...

I thought I might add a different perspective to the discussion: Education.

I'm new to the corporate world as I have been in public education for nearly 12 years prior to...

My initial thought is no, I would still not have paid for a subscription. Microsoft has set a precedent of releasing software that should have stayed in development longer, working...

The idea of charging for service packs is absurd with the current model of software deployment. That model being - get it out the door on time with little regard...

Are you running Standard Edition? If so, in the maintenance plan, make sure the option to keep the indexes online is not selected.

We successfully ran a 2K5 instance inside of an ESX session without any troubles at my previous employer. We were actually able to run it with less "hardware" than it...