Thanks.  We downloaded yesterday and one of my programmers was looking at it, we'll get together today to see if she got it installed (I had the pleasure of being...

That's an interesting construct, and it worked.

I thought for some reason you couldn't nest case statements, but apparently you can.

Rather ugly in a syntax sense, but perhaps you've got it! ...

The query plan is below.  It obviously combines the two queries into one.

as to the question about invalid data -- well, that's kind of the point, ISNUMERIC ought to catch...

I agree, having just gone through this I also chose "none of the above" because it is "not required".

Bad wording.

We migrated from a 2G 4x700Mhz server on W2K to a 32G 4x2.8G server on W2003.

We went to W2003 primarily so we could make use of 32G instead of 8G...

You really want to help or do you want access?

If you really want to help, build a case of what is wrong -- what needs doing, the kind of problems...

Be nice if I could, but these are all users of a couple of databases, so the workload is not easily partitioned among instances.

I can say that so far it's...

On SQL 2000 EE SP3 I can confirm that it does understand 20000 as 20G.  I moved it up and down and could see the memory usage changing on task...

Sorry, I guess I kind of lost track of where to post problem reports, and was thinking this was it (since I saw others here).

I now see there is a...

Many SQL developers are MS developers and have MSDN Universal or similar which gives them Visio.

For design (not, IMO, administration and maintenance) I think Visio is a great tool, the...

Here's a rearranged version of the popular SP_WHO2 which, when run with a specific PID, will show the sql statement being executed.  At least mostly -- some things like UDF's,...

Do you have a microsoft reference for that?

I'm not disputing it, but it addresses a discussion I have had internally and I have not seen that written down from Microsoft.

I've often wondered the same.  We have 4 CPU's and I am convinced that at times we get basically hung up because some query creates a huge number of parallel...

We did something once that might satisfy you, though honestly I'm not sure that your approach isn't better served with triggers, at least setting an update date/time in the sale...

For such a huge amount of write activity I would expect switching to Raid-5 would be a bad idea.  For write activity while each logical block write might require two...