O'Reilly logo

Writing Stored Procedures for Microsoft SQL Server by Matthew Shepker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Utility Stored Procedure Code

Over the next few pages, I present you with a great deal of source code. This code has been compiled over the past few years. Some of these procedures are fixes and modifications to Microsoft stored procedures, and others were written to make my life easier. As with any programming language, one good way to learn about utility stored procedures is to look at other people's source code. If you want to use any of these procedures and do not want to type them in, you can download the source code from this book's Web site, at http://www.samspublishing.com.

Updating Index Statistics

One of the most important things you can do with the indexes on your tables is update the usage statistics on those indexes. This is done ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required