(Mike Liu and Tony Lau) Performance engineering is a discipline that entails determining and reporting the current performance of a software solution. It involves simulating a large number of concurrent users, collecting diagnostic data, plotting graphs, doing performance analysis, and engineering p
Other News
Add Custom XML Documentation Capability To Your SQL Code
(Michael Sorens) If you’ve ever worked with sophisticated database systems or large applications you’ve probably accumulated sizable libraries of stored procedure code. Such libraries typically hold a few hundred stored procedures, ranging from perhaps a few hundred lines of code to thousands of lin
Tips for Copying Catalog Statistics from Production to Test Subsystems
(Billy Sundarrajan) Application developers and database administrators often face challenges with differing access paths in Production and Test DB2 subsystems when performing an EXPLAIN for a given SQL. In most installations, tables in Test subsystems are a lot smaller than the ones in Production su
Extending the GridView to Include Sort Arrows
(Scott Mitchell) Before ASP.NET version 2.0 was released, I wrote a book and dozens of articles on the DataGrid control, which was the most functional data Web control in the ASP.NET 1.x toolbox. While the DataGrid still exists in ASP.NET 2.0, the GridView control serves as a much more functional an
Extension Methods
(David Jeavon) I have only just recently had the time to play with the new features available in VS 2008 and one of the first things that I thought I would take a look at were Extension Methods.
anyType xml message routing in ESB
(Edwin Biemond) For a customer I had to route the several different xml messages of a message handling system to the right backoffice database. I want to do this with the esb soa suite, so I need xml schema’s of these message to map the data. I can use for every xml message type a different queue so
Filtering and Grouping: A Comparison of SQL, Linux Scripting, and Ruby
(Casimir Saternos) It is common to consider software development as a creative, almost artistic endeavor today, with the goal being software that is not only functional but in some measure elegant, useful, and well designed. However, IT professionals are also called upon to at times to act in a “per
On forcing a nested loop join instead of a hash join
(René Nyffenegger) I have two tables that I want to join with a nested loop.
Query Execution Statistics
(Greg Larsen) In my last article I talked about tracking performance of TSQL statements (http://www.sql-server-performance.com/articles/per/tsql_statement_performance_p1.aspx). In that article I discussed a number of different ways to obtain performance information for your query statement or set
Reporting Services: Customize Automatically Created Parameter Support Objects
(William Pearson) As we learned in Mastering OLAP Reports: Parameters for Analysis Services Reporting, Pt. I and Mastering OLAP Reports: Parameters for Analysis Services Reporting, Pt. II, a common enterprise reporting requirement is the capability to filter reports at run time for specific informat