Purging SQL Table without impacting the users
Atul Singh
October 12, 2018
This happens very rarely but sometime I have been asked to conditional purge the SQL table without impacting the Users (So we can not use t...
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
Friday, 12 October 2018
Sunday, 14 August 2016
NULL behaviour in Oracle
Atul Singh
August 14, 2016
NULL, as known in SQL, a special marker and keyword indicating that something has no value. A value of NULL is different from an empty or z...
Tuesday, 7 June 2016
Tuning SQL Statement #4
Atul Singh
June 07, 2016
Using Functions in Queries When using functions in SQL statements it is best to keep the functions away from any columns involving index m...
Monday, 23 May 2016
Tuning SQL Statement #3
Atul Singh
May 23, 2016
Tuning SQL Statement #1....... Tuning SQL Statement #2....... Consider whether a UNION ALL will suffice in place of a UNION. The UNION ...
Wednesday, 27 April 2016
Tuning SQL Statement #2
Atul Singh
April 27, 2016
Tuning SQL Statement #1....... Tuning SQL Statement #3....... • The UNION statement performs the equivalent of a SELECT DISTINCT on t...
Tuesday, 26 April 2016
Tuning SQL Statement #1
Atul Singh
April 26, 2016
• Try to use explicit columns and try to read columns in index orders if possible, even to the point of reading indexes and not tables....
Friday, 20 November 2015
5 Tips For Better DataStage Design #5
Atul Singh
November 20, 2015
#1. Use the Data Set Management utility, which is available in the Tools menu of the DataStage Designer or the DataStage Manager, to exami...
Wednesday, 9 September 2015
DataStage Terminology
Unknown
September 09, 2015
DataStage Term Description DataStage Administrator Client program that is used to manage the ...
Thursday, 27 August 2015
DB2 Column Compare Tool
Unknown
August 27, 2015
Whenever, we are working in Datawarehouse / Database (Oracle / MSSQL / DB2) projects, we often need to compare to tables co...
