I would say that as far as the power of the workstation it really depends on what you want to do.

Personally, I would be more concerned with RAM than processor...

When their voices go up you way YES when the voices go down you say NO. This has got me through 12 years of marriage.

I've had whole conversations with...

I was given a cell phone 3 years ago. Presumably because socks were more expensive.

It had £10 of free calls on it and I still have £1.50 left on...

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