0 - 6 of 6 tags for @dnoeth@Raja_KT

Hi All,
 
Please can anybody help me out with below query.
We are receving timestamp values from our server which is located in UK right now.We need to convert all the timestamp values in UTC for our reports.
As per my understanding,UK will be in BST during Summers and will be in GMT, the rest of the year.

Hi,
I have read that in access logging you ask the database to log who’s doing what on a given object. The information stored is based on the object not the SQL fired or the user who fired it.So my question is why we do this when we have same info in dbql object table.
 

Hello Team,
 
Require help in tuning below query. with existing filter & join conditons i tried to tune the query but no major breakthrough in reducing Runtime and Total CPU. The query is stuck in Step 4 where it is using Sliding Window Merge JOIN, it was  in same step for 25 min and eventually aborted by me. 

Hi, 
Here are my sample tables. 

Table A	

Col1	Col2	Col3
1	A	ABC
2	B	ABD
3	C	ADC



Table B	

Col1	Col2	Col3
1	A	ABC
2	B	ABD

 

Query 1

Select * from  A 
Left outer join  B 
ON A.Col1 =B.Col1 
and A.Col1 =B.Col1
Where 
 B.Col1 is Null
and B.Col2 is Null

 

Hi All,
My Company does not encourage me to use Stored proc since it a single amp operation and consumes lot of resource.
But I have also heard that single amp query works faster, so it sounds quite contradictory can some one expain me the same.
Thanks in Advance!!

Hi All,
 
I have a scenario where I can get bad records in my input file and I still want that the load should not fail while those bad records should be rejected it should log the rejected records with the reason somewhere. It is possible in some database like Vertica, 
Can it be done in Teradata ? If yes pls explain.