I find that detaching the database can help.

If you use EM you can warn the users connected to the DB and force them off.

Once detached, just delete the files for...

It seems most became DBA's by accident more than choice.

First be aware that nolock hint allows dirty reads. You can also hint an index e.g.

select * from tbl (nolock, index = IX_tbl_fld2)

This could help speed things up. If...

Thanks for the reply.

I am going to take Steve's advice and write an article. There doesn't appear to be much independent performance information on partitioned views and since I...

If you have an Active/Active cluster of SQL 2000 then you have 2 instances of SQL 2000 running on 2 hardware nodes.

Each Instance is like a separate SQL 2000 install....

I started with a degree in Electrical Engineering. I originally wrote a database 15 years ago for the engineering firm I worked for.

Eventually I found myself doing a similar...

It has always bugged me that the pop up menu on Enterprise Manager for the registered instance has the disconnect item next to the stop (stop MSSQLServer service) item.

I am...

You can use one of 3 methods to attach a set of database files:

1. sp_attach_db (works with up to 16 files)

2. sp_attach_single_file_db (works for re-creating a single log file if...

Thanks again. The link http://vyaskn.tripod.com/federated.htm was interesting.

I will post my findings shortly on the performance of partitioned view compared to original table.

As yet I haven't had a...

I asked the question about partitioned views (not the distributed type on federated servers).

Thanks for the response. I am familiar with the benchmarking and the way Federated SQL servers...

There is a bug introduced in SQL2000 SP1 described in KB article Q302892.

If you have an Operator in SQL Agent that uses more than one email account, any notification for...

Under most circumstances I agree that an Identity column is a simple method for numbering rows.

On occasions where an insert is needed with the "Set Identity_Insert ON" function be aware...

NOTE: If you are using Integrated Security then the windows logins are mapped in the Windows Registry on the local SQL server.

In this case you definitely have to prepare...

I covered this issue with the Y2k compliance stuff.

SQL 6.5 required you to stop the services before changing the system time.

SQL7/2000 did not have a problem with changes to the...

Check the virtual memory settings in the OS.

The minimum pagefile should be RAM + 11MB.

Also check if you are getting blocks by running sp_who2 active. This will tell you...