Search Results

Post by: greg00, Mar 23, 2006 in forum: General DBA Questions

<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...

Post by: greg00, Mar 22, 2006 in forum: General DBA Questions

quote:Originally posted by Twan if cpu is the same on both by duration isn't and both queries are run locally on the machine, then it has to be a...

Post by: greg00, Mar 21, 2006 in forum: General DBA Questions

MORE TEST : even if i execute my query on old server PIII 1Ghz with poor sdram memory and old drive it take 6442ms instead of 17454ms on my bug...

Post by: greg00, Mar 21, 2006 in forum: General DBA Questions

quote:Originally posted by Twan Hi ya, same memory config? same applications installed? same version of MDAC? same network cards/settings, no...

Post by: greg00, Mar 21, 2006 in forum: General DBA Questions

quote:Originally posted by Adriaan quote:There is several inner join in my query (on 5 table and 1 view and 1 user function) The UDF is the #1...

Thread by: greg00, Mar 21, 2006, 9 replies, in forum: General DBA Questions

Hi, PROBLEM : it's a query performance problem. There is several inner join in my query (on 5 table and 1 view and 1 user function) return 23000...