Purging SQL Table without impacting the users
Atul Singh
October 11, 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
Thursday, October 11, 2018
Sunday, August 14, 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, June 7, 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...
Sunday, May 22, 2016
Tuning SQL Statement #3
Atul Singh
May 22, 2016
Tuning SQL Statement #1....... Tuning SQL Statement #2....... Consider whether a UNION ALL will suffice in place of a UNION. The UNION ...
Tuesday, April 26, 2016
Tuning SQL Statement #2
Atul Singh
April 26, 2016
Tuning SQL Statement #1....... Tuning SQL Statement #3....... • The UNION statement performs the equivalent of a SELECT DISTINCT on t...
Monday, April 25, 2016
Tuning SQL Statement #1
Atul Singh
April 25, 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....
Thursday, November 19, 2015
5 Tips For Better DataStage Design #5
Atul Singh
November 19, 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, September 9, 2015
DataStage Terminology
Unknown
September 09, 2015
DataStage Term Description DataStage Administrator Client program that is used to manage the ...
Thursday, August 27, 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...
