Linked server query is really really slow!
Title: Linked server query is really really slow! I'm trying to select one record from a SQL database that has 1.3 mil records based on the serial number. Once I find that one record based on the serial number I want to query the linked server(Unidata 5.2) and pull in some records from a line item detail file 450k records. Getting one line item is the reason for the second match on the part number. Is there another way to structure this to be a little faster? I'm hoping it is just a case of moving stuff around in the query to make it run better. Or do I just have to start playing with indexes or try to dump the data out to SQL? SELECT TOP 1 dbo.Order_Details_View.Sales_Order_Number, dbo.Order_Details_View.Part_Number, DERIVEDTBL.Unit_Price, DERIVEDTBL.Cust_Nbr, DERIVEDTBL.Cust_Name, DERIVEDTBL.Ship_Name, DERIVEDTBL.Ship_Address, DERIVEDTBL.Ship_City, DERIVEDTBL.Ship_State, DERIVEDTBL.Ship_Zip, DERIVEDTBL.Bill_Of_Lading, DERIVEDTBL.Pro_Nbr, DERIVEDTBL.Description, DERIVEDTBL.Line_Nbr, dbo.Order_Details_View.Serial_Number, DERIVEDTBL.So_Nbr, DERIVEDTBL.Part_Nbr_Strip FROM dbo.Order_Details_View INNER JOIN (SELECT * FROM OPENQUERY(M2K, 'SELECT * FROM SOD_PROD_LIFE') AS M2K1) DERIVEDTBL ON dbo.Order_Details_View.Sales_Order_Number = DERIVEDTBL.So_Nbr AND dbo.Order_Details_View.Part_Number = DERIVEDTBL.Part_Nbr_Strip COLLATE SQL_Latin1_General_CP1_CI_AS WHERE (dbo.Order_Details_View.Serial_Number = N'AM029516954') Jeffrey Lettau ERP Systems Manager polkaudio -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Massive RedBack Network Traffic
I've only see the problem like this with a bad network card or port on a switch. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baruch Salamander Sent: Thursday, February 05, 2004 10:05 AM To: [EMAIL PROTECTED] Subject: Massive RedBack Network Traffic Our network consists of several servers, of which one is Universe 10.0 on W2000, which runs fine. After adding a W2000 RedBack server to our existing network, massive amount of traffic and collision has been detected. The traffic takes place as soon as the RedBack server is plugged in before even running anything. The traffic stops when the server is unplugged. Has anyone experienced this problem. If so, how was it resolved? Any other tips would be helpful. Thanks in advance, Baruch -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Avante/Infoflo training.
http://msg.epicor.com/msg/Services/Education/default.htm Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Raven Sent: Wednesday, February 11, 2004 11:31 AM To: [EMAIL PROTECTED] Subject: Avante/Infoflo training. I have a client that is looking for Avante/Infoflo user training in accounting and inventory control. What is available outside Epicor. Dave Raven Mobile(949) 228 2224 e Fax (815)4259364 P.O. Box 17811, Irvine CA 92623-7811 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [OT] America Has First Flight (?)
And also don't forget that we have total freedom of speech and there is no propaganda in the media like other countries. Freedom comes at a price, and the more money you have the freer you are. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins Sent: Wednesday, March 31, 2004 4:25 PM To: 'U2 Users Discussion List' Subject: RE: [OT] America Has First Flight (?) A Greek or an Egyptian I think - it was a slipstick. Not sure whether it handled multivalues... Jayjay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cliff Bennett Sent: 27 March 2004 01:32 To: U2 Users Discussion List Subject: [OT] America Has First Flight (?) But, but ... I was taught since grade school that all important discoveries and inventions were made by (mostly) Americans in (always) America. Could it be otherwise? This understanding of our accomplishments and yes, even destiny, has underpinned our unparalleled prominence on the World Stage. This revelation that a red-white-and-blue American was not actually the first to fly is shocking. Perhaps we were second or third with railroads and automobiles also? Whoo-ee, I feel like Neo in the Matrix, removing the blinders that hid the vast incubation farms where people lived in ignorance. I guess I can handle sharing the credit for human knowledge and developments with other countries. Just don't ask me/us to share authority decisions or participate in ecological improvements. OK, back to our regularly scheduled U2 topics. Say ... didn't an American invent the first computer and compiler and database and ... Happy Friday! -Cliff - Original Message - From: "John Jenkins" <[EMAIL PROTECTED]> To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]> Sent: Friday, March 26, 2004 3:49 PM Subject: RE: [OT] Airplane flights and stuff was Re: Optimisation ? : A Welshman flew a 'plane in the reign of the emperor Tiberius - you can see : the evidence yourself - there's a coin with a primitive 'plane on it and the : date on the coin says (in Roman numerals naturally) "TIBERIVS IMPERATOR" and : on the obverse "LXVI B.C." : : Regards : : JayJAy -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Email report
The attachment is just a text file. Not a virus of any sort. I'm guessing that the e-mail was sent to the general list. Maybe everyone is getting kicked out in 3 days? Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard A. Wilson Sent: Tuesday, April 06, 2004 9:21 AM To: U2 Users Discussion List Subject: Re: Email report I think it was sent to everyone, I'll wait till someone more daring opens the attachment Harry Hambrick wrote: > why did I get this message and why would my account be disabled? I > haven't participated in the long winded conversation/argument that's > been going on in the list and rarely post anything to the list. > > What's up? > > Harry Hambrick > Geac Public Safety > 813-207-6983 > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf Of [EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 10:21 AM > To: [EMAIL PROTECTED] > Subject: Email report > > >Dear user of e-mail server "Oliver.com", >Your e-mail account will be disabled because of improper using in > next >three days, if you are still wishing to use it, please, resign your >account information. >For more information see the attached file. >Cheers, >The Oliver.com team [1]http://www.oliver.com > > References > >1. http://www.oliver.com/ > -- Richard A. Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 401-231-3943 [EMAIL PROTECTED] www.lakeside-systems.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Personal UD6.0 Max number of users reached.
I just installed it and got to login with out issues. After I messed up my database and had to reload it I'm getting the error telling me that the Max number of users has been reached. When I go into the ADMIN tool and look, there is no one logged in. I got 2 our of the 2 connections free. Is there something else I should look for? Is there a different kind of connection that will take a license but not show under the users? Jeffrey Lettau ERP Systems Manager polkaudio -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Personal UD6.0 Max number of users reached.
Ok, I disabled the Redback utility service and Redback scheduler. I'm guessing that this took my 2 accounts? Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Friday, April 09, 2004 12:04 PM To: U2 Users Discussion List Subject: Personal UD6.0 Max number of users reached. I just installed it and got to login with out issues. After I messed up my database and had to reload it I'm getting the error telling me that the Max number of users has been reached. When I go into the ADMIN tool and look, there is no one logged in. I got 2 our of the 2 connections free. Is there something else I should look for? Is there a different kind of connection that will take a license but not show under the users? Jeffrey Lettau ERP Systems Manager polkaudio -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
