Noel/PW,

Thanks for the replies. If nothing else its good to know that I'm not going mad - there is something awry in SQL Server here. At least we're aare of...

PW,

Thanks for that. There's 3 of us here scratching our heads over this and that explains it.

Perhaps you can explain 1 other strange thing that we are seeing. Immediately PRIOR to...

Robert,

My understanding is that there is an upgrade path between different betas therefore I would expect there would be an upgrade path from a beta to the version proper.

The interim-beta...

Barry,

It seems as though you're referring to the new ROW_NUMBER() function that is/will be provided in SQL Server 2005.

I don't know of any pitfalls to using it. You're right that it...

Dave,

1. Open up Books Online (BOL) from Programs-->Microsoft SQL Server-->Books Online

2. In the index type CREATE DATABASE. Double click on the resultant entry in the list

3. It'll bring up a "Topics...

I've got the CTP installed but haven't had a play with it yet Steve. As soon as I do I'll try and remember to come back here and post some...

HTML is the most obvious method that I know of to encode text formatting. So, convert your files to HTML and you can store them in a CHAR/VARCHAR/TEXT field in...

Just a guess but is the error: "SQL Server Setup could not connect to the database service for server

configuration. The error was: [Microsoft][ODBC Driver Manager] Data source

name not...

Richard,

SSIS (the new DTS) is much more functionally rich than DTS. DTS doesn't really have any heavy lifting capabilities whereas SSIS most definately does and seeing as you are using...

Bill,

CLR stuff is an obvious winner when it comes to mathematically complicated operations. String shredding and scalar functions are just 2 areas where I envisage alot of quick wins using the...

Sure, thanks Kenneth.

It looks like I have got to the bottom of it now anyway. I have managed to tune the query that was causing all the problems and my...

I really should do more investigation before I post

It turns out that 1 of the 2 queries that I thought might be causing...

Mike,

That was a great article and told me somethnig I didn't know. Thanks.

I'm interested in one thing you said though: "If you are seeing a high proportion of misses as...

Yeah, you'll have to believe me (cos I'm not going into detail) when I say that in this instance its not possible. I used the...

Hi,

Thanks for the continued advice.

We have 4 values that we have to calculate the max of. Think of them as 4 facts (for that is what they are).

The 4 values...