Viewing 15 posts - 46 through 60 (of 215 total)
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...
February 18, 2004 at 4:55 am
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! ...
February 17, 2004 at 6:41 am
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...
February 16, 2004 at 6:32 pm
I agree, having just gone through this I also chose "none of the above" because it is "not required".
Bad wording.
February 11, 2004 at 3:50 am
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...
February 4, 2004 at 5:32 pm
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...
February 4, 2004 at 4:48 am
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...
February 2, 2004 at 3:21 pm
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...
January 29, 2004 at 7:33 am
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...
January 28, 2004 at 3:00 pm
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...
January 28, 2004 at 6:02 am
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,...
January 23, 2004 at 5:23 am
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.
January 18, 2004 at 6:07 am
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...
January 9, 2004 at 6:15 am
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...
January 9, 2004 at 6:13 am
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...
January 8, 2004 at 5:43 am
Viewing 15 posts - 46 through 60 (of 215 total)