Don't worry Tomi - I have the greatest respect for Antares, Andy and a host of others.

Antares - you are right about the extra reads and that is an important...

Tim - I appreciate the link. I do have the .NET environment on my machine and am using the MDAC 2.7 (I think - it might still be 2.6)....

OK - here is some code in case I did anything wrong.

CREATE TABLE taLocation1 (

LocIDBIGINT NOT NULL,--Identify the Location

LocCodeVARCHAR(10) NOT NULL,--Human friendly code

LocDescVARCHAR(100) NULL,--Description of the Location

CONSTRAINT PK_taLocation1 PRIMARY KEY...

Great documentation on your recovery process.

One thing you might try (although we hope there is no next time)... after setting the status to emergency mode and BEFORE running DBCC.

execute ...

I have found the two methods to be statistically equal - but prefer the INDEX over the CONSTRAINT for no arguable reason

Keep in mind one more...

I agree with cheddar. Even with the great performance improvements made for cursors, this looks like one that is much better in a set-based operation.

The exception that comes to...

You should be able to substitute the server name with the IP address.

Guarddata-

Thanks Tim.

Sounds like the *NamedParameters* property is what I am looking for. Delphi 6 ships with ADO 2.1 and this property is not available here (unfortunately, neither is the...

I may be misunderstanding you so please bear with me. Seems like you are using a SELECT statement to read information from Access. In that case, you cannot...

Jackmang

You are not necessarily "corrupting" the database...but as you suggest, there might be other ways to achieve your desired result. Here are some issues which you have probably already...

Cheddar,

You are right - they are about the same for setting a single variable (I think that was part of my first comment). And for appearances, again I agree...

That seems to be the case... but we have found that the internals seem to be more efficient with the COUNT than EXISTS (at least in tables with relatively small...

I'd say it really depends a lot on your implementation. We have found the GUIDs to be really nice for configuration and lookup tables since the volume is low....

Tim,

I don't remember if we had SET NOCOUNT ON -- been over a year since that little test.

We ran the test in Query analyzer with the only difference in the...

In the tests that I have run, I have found the performance of SET and SELECT to be identical for single variable assignments. However, I am currently working in...