Author: SSWUG Research

Community

The Three Faces of ASP.NET AJAX

(Jesse Liberty and Dan Hurwitz) The new Microsoft ASP.NET AJAX web development framework (which we’ll refer to simply as AJAX throughout the rest of this article) is like a mythological figure with three faces to its personality: one is friendly but rigid, one is playful, and the third is, to most A

Community

Analyzing complex queries

(Jan Kneschke) When you ask someone how to optimize SQL queries you will always get the answer –enable the slow query log –set the long-query-time to 1-2 seconds –enable the logging of query which aren’t using an index –run EXPLAIN on the queries that are shown and optimize them with

Community

Oracle: Sorting Out Memory

(Steve Callan) Keeping track of all the different memory areas in Oracle taxes my memory. With Oracle 10g, there can be fewer parameters to keep track of – if you remember which parameters drive or affect other parameters. It is very common to see numerous reporting scripts in a production environme