Yes but as I said, the performance hit is as a result of not having DRI in the database and this resulting in orphaned records.

DRI does not affect SELECT statements...

Thanks, the bit meaning is more robust than relying on naming conventions.

The query I was basing my work on was

select object_name(fkeyid)AS ReferencingTable,object_name(rkeyid) AS PrimaryTable,object_name(constid)AS FKName,c1.name AS ReferencingColumn,c2.name AS ReferencedColumn

from...

If you were going to match up Customer to Orders anyway then DRI should have no affect.

If all you wanted were Orders without the customer information then having to...

Do you happen to know what the bit flag is?

What I am trying to do is write a query that will find out when a foreign key constraint isn't supported...

I am trying to make the distinction between entries created by CREATE INDEX vs those created by CREATE STATISTICS.

I know that the _WA_SYS entries are where SQL Server itself generates...

DRI does not impact performance of SELECTs directly.

Indirectly its absence might because you are trawling through more (orphaned) records to achieve a stated goal.

If the query uses INNER JOINS it...

Look in BOL for the -h hint. This lets you specify how many records are uploaded at once.

I've just had to run a 220,000,000 record upload and I would...

Spot on DC Peterson!

The design of the real package is very similar to my example.

A CommonObject held about 50 fields that were common for any single specific table no matter...

Just as a matter of interest what design would you put in place instead of the example given?

Windows for Warehouses? Shortly after the release of Windows for Workgroups.

Then there was a Geordie version of Windows.

For those of you who don't know what Geordies are, they...

One of the great disillusionments of my career is seeing the backend databases for applications that are making money hand over fist.

I would agree that many of the database designs...

I didn't argue for well tested stored procedures replacing DRI. That was the opinion of Phil Factor.

I strongly believe that whether to use DRI is a design issue and...

Possibly something to do with the time taken to open/close a connection to the database?

What I meant was that, depending on the tool and font, double underscore is not visibly that different from single underscore.

COS(1) produces 0.54

SIN = Opposite/Hypotenuse

COS = Adjacent/Hypotenuse

TAN = Adjacent/Opposite

SIN, COS, TAN functions in SQL server work on radians NOT degrees. As a circle is represented by 2 PI radians...