June 2009 Blog Posts

Forced Parameterization: A Turbo Button?

I never had the need to turn on the PARAMETERIZATION FORCED database option until this week.  We pretty much use only stored procedures for our internal applications so the execution plans are almost always in cache and reused.  This practice of using parameterized stored procedure calls, together with attention to detail in query and index tuning, allows us to comfortably handle several thousand requests per second on commodity hardware without taking special measures. The Perfect Storm We acquired a third-party application which had to sustain thousands of batch requests per second in order to keep up with our peak demand.  Our first...

Restore Database Stored Procedure

A user in the SQL Server public newsgroups asked about how to restore a database with many files and rename during the process: I am restoring a database onto another server with different drive sizes and mappings. The thing is, I have over...