2nd problem. Steve Jones posted a link in one of his editorials for a tool from Red Gate software that tracks the dependencies.

They don't call toilet cleaners, toilet cleaners either. They are either sanitation engineers or hygiene executives.

So basically small objects, those under 64Kb will inflate and waste up to 7/8 of their storage.

Is there no way that you can insert a dummy entry into your ds table that you app won't pick up?

The example in the article worked on the principle that...

You are better off using an external app for address matching.

SOUNDEX is OK but it always retains the 1st character and it deals with letters on an individual basic.

Philistine an...

SQL Server doesn't like inequality comparisons.

Equality operations are generally fastest

Greater than or less than operators are next

Inequality is last.

I find that WHERE FieldX IN('A','B','C') works better for me also, provided...

When you say that it doesn't work what exactly do you mean?

Presumably PHCR_Record has an identity column?

Is @@IDENTITY returning an incorrect value? If so use SCOPE_IDENTITY() instead.

Use your app to generate flat files then use BCP or BULK INSERT to import the files.

Should be faster than a very fast thing

Also, drop the indexes, foreign keys, primary...

http://www.sqlservercentral.com/columnists/jBulinckx/indexedviewswithouterjoins.asp

OK adding extra fields into an index eliminates the bookmark lookup but surely they become unavoidable because we can't index everything! Well we can but the performance penalty for...

Just for information purposes are bookmark lookups bad and if so how do you reduce them?

I've just found a book called "Microsoft SQL 2000 Performance Tuning Technical Reference" which discusses CHECKPOINT in less that all-encompassing details.

YES - using CHECKPOINT will increase disk writes but...

I remember when

Gold and Platinum credit cards used to indicate wealth.

The term "Executive" used to be a noteworthy career achievement

When going to University meant that you were bright.

I don't...

Any woman in any nightclub could tell you that

To do what exactly?

If you just want a list of fields then SET FMTONLY ON before the query will give you what you need.