(Charles Hooper) While reading the “Pro Oracle SQL” book I learned something interesting. Commenting your work can improve database performance. You certainly are aware that thoroughly documenting what you do could prevent hours of headaches that might appear later when trying to investigate probl
Other News
GLOBAL TEMPORARY TABLEs and GATHER_TABLE_STATS
(Hemant K Chitale) If you use a Global Temporary Table in your application code, watch where and how you run GATHER_TABLE_STATS on it.
How to Export Crystal Reports without using the Report Viewer
(David Weaver) This article will show how to eliminate the Crystal Reports report viewer to allow reports to be exported in one step.
The benefits of SCHEMABINDING
(Mike Lewis) SCHEMABINDING is an option that can be applied to Views or Functions. When used, it forces SQL Server to create dependencies between any objects referenced within the View or Function, to the View or Function itself. What this means is that the referenced objects cannot have their def
DB2 for z/OS Database Recovery – Get it Right
(Lockwood Lyon) Database backup copies may not be enough to ensure data recoverability. The DBA must “bake” recoverability into the database design process; additionally, for current systems, the DBA needs to know whether current backup processes support recovery procedures that will meet applicatio
An Exploration In Separating Hash-Change Events From Programmatic Hash Updates
(Ben Nadel) A couple of weeks ago, I presented the idea of learning about "best practices" in event-driven programming by looking at the way the browser handles user-generated vs. programmatic updates.
Temporary files, binlog_cache_size, and row-based binary logging
(Chris Calender) Even when the output of EXPLAIN doesn’t show “using temporary”, a temporary file may still be used in certain cases.
And the DB2 10 DSNZPARM story continues: Changed defaults
(Willie Favero) So far I’ve discussed system parameters that are being deprecated in DB2 10 and system parameters that are being removed form the product in DB2 10.
Configuring WS-Security for JAX-RPC web services in WebSphere Process Server V7
(Samir Nasser) This tutorial shows you how to configure WS-Security and the WebSphere environment so that a JSP client in one WebSphere cell can call a JAX-RPC Web service in WebSphere Process Server in a different cell.
Analyzing SQL Server Plan Cache Performance Using DMVs
(Tim Ford) So far I see you’ve covered persisting SQL Server performance counter values obtained from sys.dm_os_performance_counters and querying the results for buffer pool information. What about the other aspect of SQL Server memory: plan cache?