(Marion Behnen and Kavya Rao) IBM DB2 Text Search enables users to create full-text search applications in a DB2 for Linux, UNIX, and Windows database. Full-text search is fully integrated into database query processing, but text-search indices are file system-based, and backup requires synchronizat
Other News
Restoring SQL Server system databases msdb and model
(Atif Shehzad) Due to a recent rebuild of the master database for a SQL Server instance, I now need to restore the msdb and model databases. In this tip we walk through the process that you need to follow to restore the model and msdb databases successfully.
Error Handling Techniques
Error Handling Techniques In my opinion, Error handling is one of most important skills in enterprise level software. Often, handling errors is an afterthought, and is enhanced more often through need to debug code rather than a planned approach. I like to think of error handling with a few different dynamics. Managing the Proccess Flow Continue Processing Stop the process […]
Merge Comments
Merge Comments Today I had a number of comments regarding an SQL merge process. Jason: If you do the update first you have X rows in the table that it has to evaluate to join on. Now when you delete you still have X rows to join on. I believe you said you do the insert after the update so […]
How to save execution plan in XML format
(SqlServerProblema) Use SQL Server Management Studio to save execution plans as an XML file, and to open them for viewing.
XML – Castor Parser
(Mahesh Lavannis) Castor is an open source XML parser, similar to JAXB (which is a Java Standard).
C/C++: The Hazards of Using a Minimal Amount of Code
(Andrey Karpov) This first article in a series devoted to how C/C++ programmers play with fire without knowing it, will discuss how programmers often attempt to explicitly call a constructor.
Keep an eye on ASP.NET applications with health monitoring
(Tony Patton) Application errors occur in production regardless of how much planning and testing is done, thus the need for application support. Production systems should be monitored from the ground up with the application being the last level.
Tuning query with database link using USE_NL hint
(Marko Sutic) I’ve just realized that I’m never fully satisfied after tuning queries with database links. Yes, I manage to improve performance significantly but I’m always missing some answers.
Oracle Database whoami
(Uwe Hesse) Just a little script that I use in my courses to see who I am