The only reference that I could find was SQL Server 2000 High Availability Series Implementing Network Load Balancing

I always thought that clustering SQL servers was simply to provide resilience....

My first job involved an HP3000/42, 52 and model 70 mini-computer and the 300MB disk drives for that were about the size of a laundrette washing machine. I suspect...

Are you experiencing problems with the way you are doing things at present?

If not then I would take the view that if it isn't broke don't fix it.

I try and...

If your unique ID is your primary key or a unique index then SELECT XYZ FROM dbo.abc WHERE key='232' is going to be fast no matter how many records you...

No, there is no drive mapping involved. It is simply a case of writing to a local directory.

I have tried right-clicking on the scheduled job and adding my intended...

Jeff,

Have you seen the trick where you do a completely superfluous WHERE {ClusterIndex} BETWEEN {ClusterIndex}.MinValue AND {ClusterIndex}.MaxValue

In SQL2000 this can force the clustered index seek even though the clause does...

I don't have BOL in front of me but look for a procedure with a name like sp_resetstatus.

Once you have done that you should be able to DROP the database.

This mind intentionally left blank

If you do WHERE {Function(field)} = {value} then you will probably do a TABLE SCAN because the value isn't an indexed value.

Probably won't matter in a small-ish database but in...

So am I correct in thinking that it is if a single transaction requires a growth in excessive of current free space limits plus one expansion?

That is (Company Removed) added to my SPAM filter and blocked internet sites!

SQL2000 also makes use of the INFORMATION_SCHEMA views. You can see the definitive list within the MASTER database.

Some of the system tables have changed in SQL2005 so I would...

bcp is one way. I use BCP to export the results from stored procedures.

You can use SQL Query Analyser .See The best kept secret about SQL Query Analyser....

It depends what you mean by huge

I had a requirement to produce a search that had certain compulsory search terms and a number of optional ones.

What I did was have...

I take it that these were not Windows Account users?

A login has an SID number which is unique to the box. SID 1 is the SA account.

If you recreated...