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 ...
Get Writing Stored Procedures for Microsoft SQL Server now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
