I've the following code which parse 2 text file, reading it record by record, and sorting them. Records are sorted by date in each file. For example :
file 1 - 1.1, 1.2, 1.3, 1.5, 1.8, 2.0, 2.3
fil...
http://www.experts-exchange.com/Programming/Languages/Scripting/Perl/Q_10142010.html
Zones:
PerlDate Answered: 04/30/1999 Rating: 6.6 Views: 0
Does any know of any optimizing/best practice procedures for MS SQL.
From the SQL Admin side and from the SQL developer side.
Thanks
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11521658.html
Zones:
MS SQL ServerDate Answered: 10/28/2000 Rating: 7.6 Views: 0
Here is my query, the performance is less than expected, but i get results. I wanted some input on optimizing this query
select a.alignment_name, a.external_id_1, a1.alignment_name, c1.name, c1....
http://www.experts-exchange.com/Database/Oracle/Q_20153099.html
Zones:
OracleDate Answered: 07/19/2001 Rating: 7.0 Views: 0
I hv a query like -
insert into tab3
(select t1.f1, t2.f2
from tab1 t1, tab2 t2
where t1.f1 = t2.f1
and t1.f2 = 'Constant value');
commit;
How can i optimize this...
http://www.experts-exchange.com/Database/Oracle/Q_20245129.html
Zones:
OracleDate Answered: 06/19/2002 Rating: 8.2 Views: 0
is it good practise to use optimzer?? becoz i don't find anybody utilizing this facility.
http://www.experts-exchange.com/Database/Oracle/Q_20306135.html
Zones:
OracleDate Answered: 06/05/2002 Rating: 8.8 Views: 0
Hello Experts !
Thanks for all you're help in the past.
Can you please help optimize this query:
UPDATE submit
SET status = CAST('ACC' AS CHAR(03)),
WHERE sid not in
(
SELECT ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20846633.html
Zones:
DatabasesDate Answered: 01/15/2004 Rating: 8.4 Views: 4
I have a table that has grown immensely and a query that pulls form this specific table. I am currently getting a timeout error on the page, because the query is taking longer to execute. I have a...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_21024548...
Zones:
Cold...Date Answered: 06/24/2004 Rating: 7.0 Views: 0
Hi friends,
Here is my code
txtAJan.Attributes.Add("onchange", "CalculateYearToDateSum(this);");
txtAFeb.Attributes.Add("onchange", "CalculateYearToDateSum(this);");
txtAMar.Attrib...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_21316313.html
Zones:
C#Date Answered: 02/16/2005 Rating: 9.2 Views: 0
Hi all,
I've read a few solid articles about how ram boosters and the like don't truely work. Some of the language in the articles went over my head, but they sounded very informed. My questio...
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/XP/Q_21399848.html
Zones:
Windows XPDate Answered: 05/19/2005 Rating: 9.0 Views: 0
Hi,
We have a oracle 8 database that is in rule based mode. I am wondering if to change it to cost based, how would the existing applications, PL/SQL Programs be affected. Thanks
http://www.experts-exchange.com/Database/Oracle/Q_21556618.html
Zones:
OracleDate Answered: 09/13/2005 Rating: 8.2 Views: 0
