I would not be nervous of the physical process but would be very nervous from the perspective of capacity.

I worked on a project where it was calculated that running 2...

Wrap your CASE statement in a CAST(CASE statement AS CHAR(3))

I have had problems with BIT fields doing peculiar things

I would try and use DTS but have three separate queries. The first would be

select

serverproperty ('servername') as 'Server' ,

ISNULL(serverproperty ('InstanceName'),'') AS 'Instance Name' ,

serverproperty ('edition') as 'Edition',

serverproperty ('productlevel')...

Firstly what are the datatypes of your three columns and why store a date as three columns when a SMALLDATETIME will do?

My approach would be to use the CONVERT statement...

Why not read a different thread then and leave us old farts to wallow in the rosy glow of nostalgia.

* * *

Of course no one is mentioning having to crimp...

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?