DataGenX - Atul's Blog: SQL

Showing posts with label SQL. Show all posts

Purging SQL Table without impacting the users

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...

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...

Using Functions in Queries When using functions in SQL statements it is best to keep the functions away from any columns involving index m...

Tuning SQL Statement #1....... Tuning SQL Statement #2....... Consider whether a UNION ALL will suffice in place of a UNION. The UNION ...

Tuning SQL Statement #1....... Tuning SQL Statement #3....... • The UNION statement performs the equivalent of a SELECT DISTINCT on t...

• 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....

#1. Use the Data Set Management utility, which is available in the Tools menu of the DataStage Designer or the DataStage Manager, to exami...

DataStage Term Description DataStage Administrator Client program that is used to manage the ...

Whenever, we are working in Datawarehouse / Database (Oracle / MSSQL / DB2) projects, we often need to compare to tables co...