White Papers

Validate Your Refactored SQL Queries With a New SQL Server 2005 Operator

Overview Often a developer needs to do the refactoring without affecting the results. When a developer refactors a query that returns the correct result set, adhering to the Hippocratic principle of "First, do no harm" will ensure to maintain quality. In this case, the principle as applied is "Make sure one returns the same results." This paper shows how a developer can use the new EXCEPT operator in SQL Server 2005 to prove that the rewritten SQL is returning the same results. It takes through a simple example, but the reader can apply the same principle to a query of any complexity.

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher: Jupitermedia
File Format: HTML
Date Published: Jul 11, 2007
Format: White Papers
Topics: Application Development, Application Servers, Programming Languages

Similiar White Papers

MSDN Webcast: Overview of the Visual Studio Team Foundation Server - Project Server 2007 Connector (Level 200)

Microsoft Office Project Server 2007 and Microsoft Visual Studio 2005 Team Foundation Server are two powerful applicatio

Publisher: Microsoft | Tags: applications, data, management, microsoft office, office, project management, software, software development

IT Manager Webcast: Application Platform: Using KPIs to Streamline Development (Level 200)

One of the main benefits of moving to Application Lifecycle Management (ALM) with an integrated (rather than ad hoc) tec

Publisher: Microsoft Tips | Tags: kpis

HostBridge Uses IBM Products to Integrate CICS Applications as Web Services

Most large organizations continue to rely on legacy systems that cannot easily be adapted to the Internet, and the lack

Publisher: IBM | Tags: applications, c++, cobol, java, legacy systems, real-time, software

Continuous Performance Management in Eclipse

Continuous performance management ("CPM") isn't a myth - it's a proven method to help your business find and resolve iss

Publisher: Quest Software | Tags: cpm, java, management

MSDN Webcast: Host Integration Server 2006 Data Providers for Host Files (Level 200)

Much mission-critical data resides in file systems, such as IBM mainframe Virtual Storage Access Method (VSAM) data sets

Publisher: Microsoft | Tags: applications, cobol, data, developers, enterprise it

Jupitermedia White Papers

Featured white papers

The Value of Location Intelligence in the Communications Industry

Pitney Bowes

Public Services are under pressure, the challenge is to do more with less. How do you improve citizen satisfaction, increase cost efficiencies and improve service delivery? The power of location intelligence is helping many local authorities...

Download now »
Best Practices for Translating Customer Satisfaction into Revenue

Citrix Online

Today's support organisations are focused on two top-level metrics: financial results and customer satisfaction. For most, it's easy to track financial performance, but customer satisfaction is akin to speaking a foreign language...

Download now »
HP print solutions and 3M

Hewlett-Packard (HP)

The objective for 3M was to optimize office printing infrastructure at 3M locations worldwide, reduce total cost and environmental footprint. Some of the business benefits acheived by switching to HP print solutions...

Download now »