Yuk. Hope they change the name of data type DATETIME2. I just hate that.

Thanks for the advice.

Very impressed by your blog enteries btw.

I think that the main reason that the report was alerting me to poor results was the SQLservers uptime was only a few days old (dmvs were reset).

However I...

Thanks Anders.

As suspected the indexes I've been given are poor choices even with the included fields.

To extend your example then I'm assuming it would have to go the the table for

select Col b, Col c from T where a=@var

where Col c wasn't included but...

What does the date represent in the string? I have two instances on my machine Standard and SQLExpress with 2 different dates.

Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86) ...

ahem... I swear to the almighty that I scanned BOL and google for that.

**feeling rather sheepish**

thank you

You need to have the Database template which comes with VS 2005 Professional.

Rob Viera's SQL Server 2000 Programming book was excellent so his 2005 book is probably worth a look.

http://www.amazon.com/Beginning-SQL-Server2005-Programming-Programmer/dp/0764584332/ref=pd_bxgy_b_img_b/104-5699322-0952764?ie=UTF8

Just to amplify I used Transcenders and was impressed. Although they should not be relied on as your total study program.