The first meeting of the SQL Server/Oracle PASS Virtual Chapter is upcoming on July 14th. Steve Simon of State Street Corporation will discuss Query Performance and Data Access Layers. http://oracle.sqlpass.org/Home.aspx
The overview of the meeting is shown below:
How often have our SQL Servers and Oracle Servers been bogged down with a myriad of users issuing lengthy and poorly constructed or poorly performing queries against our tables and views. More often than not, nearly bringing our systems to their knees. Nowhere is this truer than within the financial world where heavy number crunching is par for the course. This beginners to intermediate level hands-on presentation is aimed at the SQL Server / Oracle developer and business analyst alike and will show the attendee how we have managed to eliminate 90 % of our poorly performing queries by creating data access layers which provides our end users with a suite of well developed and tuned SQL Server /Oracle FUNCTIONS with which to render their data. The presentation will discuss the high level principles and concepts behind our data access layer, the ways in which data access layers may be implemented with both products, the scenarios under which we have benefited from their usage and then compare and contrast some of the poorly performing queries that we once had..with some more efficient and effective queries that we have now provided to our end users.