If you don't need double-byte characters (in SQL2000) use TEXT rather than NTEXT.

Phil, have you tried sp_executeSQL as a possible alternative to EXEC, it might give you a bit more...

CTRL R toggels the results pane off and on just like in QA.

By the way performance is almost acceptable if you stick 2Gb in your development machine.

My dev machine is...

No problems Daryl, there is actually a typo in your data because it has

2,1,8 AND 3,2,8 which is against the rules as 8 would be in the same 1st...

Daryl, as posted earlier there are Sudoko puzzles where there is no automated solution and you have to make a choice at some point. You can make the wrong...

Assuming you don't have SQL2005 and therefore the PIVOT function you could always resort to

DECLARE @display TABLE(ID INT IDENTITY(1,1),Display VARCHAR(50))
DECLARE @lRow TINYINT
SET @lRow = 0

DECLARE @NewRow VARCHAR(50)

INSERT INTO @display (Display)...

My apologies for the missing stored procedure.

When I started building my solution I prototyped it by bouncing values through tables and the procedure was used to remove solved cells from...

Tad William's Otherland series.

Arthur C Clarke was pretty good.

Jules Verne was probably the most prophetic.

SQL2005 is noticeably faster.

SQL Management Studio is a dog.

Security is a whole new ball game.

I suspect a lot of features will only reveal their value as and when people really...

If you want to be shackled to your old achievements then don't bother commenting your code.

As long as you work for the organisation it will always be quicker/cheaper to ask...

Diesel in the UK is around 95p per litre and petrol is around 92p.

I've just filled a 50 litre tank of diesel and expect to do around 600 miles on...

I think it is worth mentioning that both Apex SQLDoc and Innovasys DocumentX use special (and virtually identical) comment tags so that they can suck out the comments and build...

In the UK there have been a number of complaints from consumers who have been disappointed with the fuel consumption of the hybrid cars.

I think it is more a case...

Here's an embarrassing confession.

Knowing that Metadata is data about data I thought that Wayne Rooney's broken metatarsal was the cancellation of his book deal.

It depends on what you are intending to track for a sport.

• Results
• Telemetry
• Transactions at the betting shop

I worked (very briefly) at one of the smaller betting companies and their need to...

I'm not sure about the criminal bit but other than that it is a good description.

The other thing that makes Brit's good hackers is having to deliver miracles using hardware/software...