Viewing 15 posts - 1 through 15 (of 20 total)
The system is quite complicated and I am not sure it is worth sending copies of the tables out for further analysis (though I certainly don't mind if you are...
January 28, 2003 at 4:27 pm
Well it looks like I have resolved the slow select. The problem was caused by the following lines:
where FT.FT_FISCAL_YEAR=FISCAL_YYYY
and FT.FT_FISCAL_MONTH=FISCAL_MM
in the first half of the union and...
January 20, 2003 at 1:53 pm
I was having another look at some of the comments and I offer the following in case anyone is still trying to help me resolve this.
- The Parms tables (global...
January 20, 2003 at 11:45 am
Ha ha ha. Well if nothing else I am learning something here.
I don't need all the fields in the query/view but I do need most of them....
January 17, 2003 at 5:45 pm
Perhaps I need to rework this view a bit then. Your comments are much appreciated.
January 17, 2003 at 5:22 pm
Not sure what you mean by "what fields are you using from this one".
There is one other view in that first view. It is defined as:
CREATE VIEW vfsdates
as
select...
January 17, 2003 at 4:19 pm
Yes, is a view. Some of the table are quite large but I have a scaled down version on my test server.
Here is the script for the...
January 17, 2003 at 10:09 am
Thanks Antares.
I have run this query on our production server (a bit beefier but not too much) and it runs quickly. For this reason I was thinking it might...
January 16, 2003 at 5:26 pm
Well I like to stick with one brand so that I only have to learn one product line. Makes server support more streamlined. I have been buying Compaq...
January 16, 2003 at 9:05 am
Well I checked with my support contact today and here is what I said and his response:
Q: Do you know if can use a SAN with a couple of ML750's?...
January 14, 2003 at 5:40 pm
Thanks for those suggestions.
As far as how the system is used, I am not sure I can do too much predicting there. It is about to experience exponential growth...
January 14, 2003 at 1:30 pm
January 14, 2003 at 10:21 am
quote:
Do you have a link to support that? I talked to product info guy at compaq/hp who said that it wasn't...
January 14, 2003 at 9:42 am
quote:
Compaq states failover clustering isn't supported on this model.
I think Compaq elects to...
January 13, 2003 at 4:50 pm
quote:
However, as is typical, management wants to find the most cost effective way to do something, which, in this case is to...
January 13, 2003 at 4:37 pm
Viewing 15 posts - 1 through 15 (of 20 total)