Viewing 15 posts - 166 through 180 (of 215 total)
Re the other thread, that's a common solution but works only if it's one field you need. A related answer is to do that, then do another join of...
August 6, 2003 at 3:34 pm
I'm still not sure if what you are reading into this is going to do what you originally wanted.
Let's say the IIS server is X, the SQL Server is S,...
August 6, 2003 at 5:50 am
This is a specific case of a general set of problems I've never found a good solution to, maybe someone else has.
Consider the result set of:
Select a, b, etc
from table...
August 6, 2003 at 5:26 am
Well, I don't quite know how to post anything here that looks like a table. Here's something all run together that you might be able to make sense out...
August 4, 2003 at 1:26 pm
I'm coming at this as a development manager not a DBA. I think that the database names, specifically the column and table names, are much more important than the...
August 4, 2003 at 5:28 am
Re views - We've done some of that. There's just a LOT of combinations of tables, and the ones they screw up are things like customer records which can...
August 4, 2003 at 4:55 am
Coming back to some of my more difficult issues, it's correctness. While it is easy to say "it is not my responsibility to make their data analyses correct", that's...
August 3, 2003 at 4:26 pm
well, glad to know there's someone else out there dealing with this.
One thing we did do was create a "sandbox" database, whereby people could create their own objects (primarily tables...
August 3, 2003 at 10:19 am
We have a largish (130g) database we need to refresh. We also need to build it without conflicts with online user queries. We found the best bet:
- One...
July 30, 2003 at 5:12 am
Be sure the chunk size in your raid sets holds a whole cluster, especially for raid-5. Otherwise each write will end up needing to hit more than 2 disks...
July 28, 2003 at 5:49 am
I'm going to offer a counterpoint to the Dell...
Our first Data Warehouse server was a Dell 8450 with a Powervault SAN.
The 8450 CPU itself was good, but...
April 24, 2003 at 5:07 am
It's worth noting that the SQL7 log shipping procedures still work more or less. We had used those, customized slightly, before SQL2K came out. We just kept using...
April 24, 2003 at 4:47 am
I have now been told that the "immediate" part of immediate updating only applies to updates on the subscriber, and not on the publisher.
That probably explains what I saw.
March 17, 2003 at 8:45 am
I think I understand your question. One way to deal with it is nested queries. For example you want:
Select <case..... very long case....> as X
from table1, table2, table3,...
March 2, 2003 at 6:35 am
Yes, I am, and yes I could, and probably will.
I'm just disappointed that the tool designed just for this purpose is so poor. It's like no one ever learned...
February 24, 2003 at 3:37 pm
Viewing 15 posts - 166 through 180 (of 215 total)