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...

I would steer well clear of depending on sp double-underscore as a determiner for bespoke stored procedures.

Firstly, a double-underscore isn't obviously different from a single underscore.

Secondly, I feel it...

Take a step backwards.

What is the business problem that you are trying to solve

The way that I do it is to create a standard batch file that contains a bunch of OSQL scripts.

All my objects are generated in scripts which I break down...

In hindsight, no.

With foresight:

Do the update with a begin transaction but commit transaction commented out. If you get an unexpected number of records updated then run the commit.

My...