If the next version of SQL Server has as bloated a tool as Management Studio it better have a code name of "Guantanamo Bay".

Until Christmas this year I have been...

I've found that when the date is in a clustered index on SQL2000 I got slightly better performance with BETWEEN.

I tend to use BETWEEN because it makes the code more...

Never mind the features, why is SQL Management Studio so pathetically slow!

Even if you put the -nosplash switch on the SQLWB.EXE it takes an age to load.

There are bits I...

Definitely fixed growth.

I would try and size it so that an autogrow isn't going to happen unexpectedly.

I would also check out the settings for TEMPDB. Unless you have changed...

It is doing a bit comparison of a value.

If you think of an 8 bit number then

Bit 1 = 1

Bit 2 = 2

Bit 3 = 4

Bit 4 = 8

Bit...

The latest release has Triggers, stored procs, DRI, support for clustering etc.

Well worth a look even if it is just as the icing on top of a CV.

I worked briefly with an old neural net called 4Thought.

It "learnt" from the data that was supplied to it but it really was a garbage in garbage out thing.

I used...

No abscence of DRI does not hurt performance it merely makes it possible to create a situation where you have orphaned records. It does not automatically mean that orphaned...

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