PDA

View Full Version : Tips & Tricks



  1. Scheduling multiple delta load ETL's to run each minute
  2. Pass a Parameter Key Unquoted <<PARM#DISPLAY>>
  3. Appropriate usage of Data Objects
  4. using Derby database Timestamps intelligently
  5. Parameterized reports in Sql Server slow down drastically
  6. Avoid Locking in Sql Server
  7. Top N Query in Apache Derby
  8. Creating Business Alerts via SMS Text Messaging
  9. Java Memory Heap Size Error on Applet
  10. Accessing CSV files using JDBC
  11. Microsoft Excel Data Source Connection Troubleshooting
  12. Embed a carriage return into your result set
  13. Which columns are indexed for a given table (Sql Server, Oracle) ?
  14. Query Result from SQL Server procedure never returned to BIPLUS
  15. Error: The statement did not return a result set with sql server 2008 driver
  16. Making BIPLUS default application on tomcat
  17. read-only query waiting on lock in Sql Server: turbo-boost technique
  18. Window Authentication for SQL server.