Search results for query: *

Yes paul this table is Truncated every 30 mins. This table is like a Temporary physical table(tableA) where we pump the data into it ,clean the data and then transfer the data into another original production table. But the problem is with the tableA. according to your sugesstion if this...

When i run the DBCC SHOWCONFIG (tableA) i get the below results and paul you are right the extent scan Fragmentation has a value which will increase slowley. What action should i take now? there is not PK on the tableA. pls advice. DBCC SHOWCONTIG scanning 'tableA' table... Table: 'tableA'...

Thanks for Info. It helps me to investigate the problem further when it happens again. I will keep you posted what i find. Thanks

It happens once in every six months. The tableA is truncated first, then insert the records(recCount:875000) into tableA. After that when i delete some records with the delete statement below: Delete From TableA Where IsNumeric(Price1) = 0 Or ISNumeric(Price2) = 0 Or ISNumeric(Price3) = 0 Or...

Thanks Jbenson, that will fix my problem. but any one knows the reason why this happens?

I dont get any error, The DTS runs forever, never finishes the process.

Let me explain this strange issue first: In SQL Server 2000 we use DTS to insert data into a TableA. it worked fine for couple of months but recently the DTS was failing. when checked found out that it is taking forever to insert the data into TableA. for Temporary solution i do this: Drop...

sorry for the vague information. here is what i am doing. test.tcl --------- #!/bin/sh # \ exec tclsh "$0" ${1+"$@"} set result 38 puts $result return $result ----------------------------------------------------- myFile.php --------- <?php global $res; $res = exec ("test.tcl") ; echo $res...

Didnt Worl.

How can i execute a TCL Script from PHP. and i want to use the Return value of TCL script in PHP. Please Advise.

How can i call a TCL script from PHP and return a value from TCL to php. Please Help!!!

1> Does ActiveState Expect needs a license. 2> Can i use ActiveSate Perl with Expect on windows. 3> what is the best language to use with expect. Thanks in advance

Thank You Mike it helped me a lot.

I have a TableA with the following data: ------------ Col1 Col2 ----------- A A1 A A1 A A1 B B1 B B2 C C1 C C2 C C3 D D1 i need to get this Query Result: A A1,A1,A1 B B1,B2 C C1,C2,C3 D D1 Thanks in Advance:)

Hi all, Our sql server 2000 stops responding once a month. when we truncate our 3 log tables it start working fine. I want to know the reason whats causing SQL Server 2000 not to respond? thanks in advance

How to return the Nth to Mth row of a particular query? thanks in advance

a simple question, select cast(156/100 as numeric(13,3)) output i get is 1.000 but in actual it should be 1.560 please help...

Thank You

Please Help!!! Is there any better way to write this query to improve performance. Total Records are 5,00,000 records Select Distinct A.col1 ,Null Col2 ,A.Col3 ,Null Col4 ,A.Col5 From Table1 A Where Not Exists ( Select * From Table2 B Where A.Col1 = B.Col1 And A.Col5 = B.Col5 ) Thanks

i want to insert datetime into mssql server2000 datetime field. thanks