At least America is big enough to form a self-contained market!

Britain is probably the most open place as regards aliens buying up its industries and asset stripping.

I remain convinced the...

I don't know if it is still true, but if you wanted a cheap car that had twice the life of any other, never broke down and did better mpg...

Try the old DOS For command

for %f in (n*.sql) do OSQL -U dhuserid -P dhpass -S server2000 -d dh_db -i %f -o %f.log -n

Try putting

SET NOCOUNT ON at the head of your script but be warned, it doesn't suppress the message in all cases.

It IS consistent, but I have found that when using...

SQL uses single quotes not double

INSERT INTO tbMenus

(tbMenus_ItemID,

tbMenus_Item,

tbMenus_Parent_ItemID,

luDirectory_ID,

tbMenus_Item_Link,

tbMenus_Item_Link_Image,

tbMenus_Item_Full_URL,

tbMenus_Sequence,

tbMenus_Condition_text)

VALUES

(335,

'| GSL Account Search',

,

6,

,

,

'javascript:window.open(\''http://addcsr11:8080/CSR/Jsp/search.jsp\'',\''ExpressPay\'',\''\'').focus();void(0)',

12,);

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