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 Grade: C 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
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 Grade: C 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 Grade: A 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 Grade: A 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 Grade: A 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...
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 Grade: A 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 Grade: A 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 Grade: A Views: 0
