On TV.com: Dollhouse CANCELED, What Went Wrong?
BNET Business Network:
BNET
TechRepublic
ZDNet

FREE Registration is required

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.

(Is this item miscategorized? Does it need more tags? Let us know.)

Format:HTML
Date:Apr 2007

People who downloaded this item also downloaded

White Paper Keeping Your SQL Server Databases Defragmented with Diskeeper
White Paper Top 10 Things You Should Know About Optimizing SQL Server Performance
White Paper 10 Steps To Secure Your SQL Server
Webcast MSDN Webcast: Creating Customizable Applications Using Web Parts With Visual Studio 2005 and ASP.NET 2.0 (Level 300)
White Paper Choosing Microsoft SQL Server 2005 for Data Warehousing

Top results from Application Development

White Paper CRM Media - Best Practices: Software-as-a-Service
White Paper Web 2.0 and Sales Process Management
White Paper Designing High Availability for Internet Information Services
Webcast Quest Connect Archive: white papers, demos and more!
White Paper Spend 3 minutes with free EBS ROI Tool - and Save Thousands

» View all Application Development listings

advertisement

White Papers, Webcasts, and Resources

Featured Training Courses

  • Smart Tech Expert advice on innovations in healthcare and the green technologies that make it happen. Find out more
  • Smart Business Discussion and advice on management issues that revolve around making your world smarter and more useful. More Smart Advice
  • Smart People The best and worst moves in the management and strategy trenches. Learn More

Returning users: Log In Here!

Already registered on BNET, TechRepublic, or ZDNet? Simply log in.

Free Membership: Sign Up Now!

Sign up for a free membership today and get instant and unlimited access to one of the largest databases of white papers, webcasts, and casestudies anywhere. Your FREE membership allows you to:

  • Download an unlimited amount of content, including classic and current white papers, case studies, webcasts and more
  • Track content on your chosen topics of interest
  • Receive targeted email alerts when your favorite content is added
  • Save content for future reading
  • Receive our member newsletter

When you register to access this library, you allow us to share your information with companies that produce products or services featured in the library--so that such companies may contact you with information and offers regarding their products and services. This enables us to keep the library a free service. As a library registrant, you will receive a complimentary subscription to the ZDNet white paper newsletter and e-mail Must-Read News Alerts. You can unsubscribe from these at any time. By clicking the Sign up button, you indicate that you agree to our Terms and Conditions and have read and understand our Privacy Policy (updated).