(Charles Hooper) An interesting quirk was recently brought to my attention by Mich Talebzadeh. He generated a 10046 trace at level 8 for a session, executed some SQL statements, disabled the trace, and then processed the resulting trace file with TKPROF. His TKPROF output included the following:
Other News
My First Experience Running SLOB – Don’t repeat my errors (AWR)
(Yury Velikanov) If you are wondering what I am busy with then this post explains it.
Caching behavior of ASP.Net XmlDataSource control
(Kushal) XmlDataSource can be used to bind hierarchical data. In our web application, we used it to bind to asp.net menu control dynamically. Visibility of the menu items was based on a particular user input i.e. based on the user input, menu items would be made visible/invisible.
Metrics have been enhanced for DB2 stored procedures and UDFs
(Willie Favero) For all of you that love to do performance and tuning of you DB2 subsystems, DB2 land is about to make your job a whole lot easier in the stored procedure and user-defined function (UDF) categories by improving some of the existing metrics and adding a few new ones.
Tuning an IBM DB2 for z/OS Application: I/O Constraints
(Lockwood Lyon) Since relieving I/O constraints usually translates into faster execution times, it can become one of the major goals of an IT support group. Many applications have Service Level Agreements (SLRs) that promise quick turnaround or acceptable on-line response time.
Jekyll and Hyde or The case of the multiple identity syndrome – Using Identity Cross References in Oracle 11g SOA Suite
(Lucas Jellema) The 11g SOA Suite brings us the Service Fabric that has messages flowing from one SCA Service Component to the next – Mediators and BPEL processes are called from inbound adapter services or external consumers and may call out to references to external providers or outbound adapter s
Visual Studio 2010 Parallel Tasks Window
(Richard Carr) Debugging code that uses parallel programming techniques presents additional difficulties to debugging software that executes on a single thread. Visual Studio provides tools that assist with these problems. One such tool is the Parallel Tasks window.
SQL SERVER – Columnstore Index and sys.dm_db_index_usage_stats
(Pinal Dave) As you know I have been writing on Columnstore Index for quite a while. Recently my friend Vinod Kumar wrote about SQL Server 2012: ColumnStore Characteristics. A fantastic read on the subject if you have yet not caught up on that subject.
SharePoint 2010 at Work – Unlocking the Mysteries of the SharePoint Data View Web Part XSL Tags
(Marc D Anderson) DVWPs are sometimes called the Swiss Army Knife of SharePoint. If you have content in SharePoint and want to display it in unique and useful ways, the DVWP is the tool you need to understand.
Zero-Downtime Schema Changes In MySQL
(Baron Schwartz) The recording of yesterday’s webinar, as well as a PDF of my slide deck, is now available. You can watch the recording and get the slides here.