July 20, 2006 08:20 PM

A Tuning Weapon for Enhancing Database Performance

Rating: (0)
SQL Server Magazine
InstantDoc ID #50474
SQL Server 2005 offers two options that help you optimize database performance: the ability to choose forced parameterization at a database level or specify within an sp_create_plan_guide stored procedure a plan guide that lets you pick and choose which values will be parameterized.

If ...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Being in a class for my MCITP:Database Administration, this article helped me understand this topic and brought me closer to certification!!

Thanks!

THOMAS10/2/2007 8:19:57 PM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS