(Luis Adalberto) Running this query will produce a list of database statements and objects that are using the most resources.
Author: SSWUG Research
OLAP SQL Part 3 – Grouping Sets
(Chris Eaton) So far we have talked about ROLLUP and CUBE. Now let’s look at GROUPING SETS. Have you ever had a query where you wanted to see the results on different groups? For example you want to see a report of sales grouped by sales rep and you also want to see sales grouped by week and geograp
Speedy PL/SQL for Oracle
(James F. Koopmann) Everyone is looking for an edge. With PL/SQL that edge is compiling the PL/SQL code into native code. This article will show you how to setup and compile your PL/SQL procedures and packages.
Document Manager with Records Manager Solution Guide
(Wei-Dong Zhu, Carlos A Cedillo, Irina Grijalba, Nicole Hughes, Romney Kernek, Lai-Fong Leung and Steve Studder) IBM DB2 Document Manager Version 8.3 is one of the newest members of the IBM Enterprise Content Management portfolio. Document Manager provides a secure and robust platform to manage the
Developing an Intranet with ASP.NET 2.0
(Daniel Winter) In the first part of this series we are going to look at a range of possible modules, such as contact and document management functions, and construct the SQL Server database for the application.
Introduction to Creating Dynamic Types with Reflection.Emit
(jconwell) Dynamic types can provide the Framework developer with efficient programming abstractions without the performance penalty usually incurred by many abstractions. By coding against interfaces and using the Factory design pattern, you can develop a framework that has the generic benefits of
Working at the Visual Studio Command Line
(John Mueller) You may not realize that the Visual Studio IDE supports command line switches, but it does. The command line switches can do everything from changing your work environment to compiling your application.
Hello, Workflow
(scott) Windows Workflow might be the most significant piece of middleware to arrive on the Windows platform since COM+ and the Distributed Transaction Coordinator. The difference is, not every application needs a distributed transaction, but nearly every application does have a workflow encoded ins
Handling Web services transactions
(Daniel Rubio) Executing individual pieces of software to perform as one unit of work is an area consistently tackled by many software platforms and an issue that is central to many business processes. The all encompassing term for this subject is named “transactions.” In the upcoming paragraphs, we
AJAX – XML for Client-Side Computing
(Coach Wei) XML is a simple, flexible text format initially designed for large-scale electronic publishing. It is flexible, open, and human-readable, and can be learned easily. XML can also be generated, parsed, analyzed, and transformed easily. It’s no wonder that XML has been widely used for serve