Month: January 2017

I’ve just posted an updated version of my SQL Script Mover utility on codeplex, here: https://sqlscriptmove.codeplex.com

This is a utility for extracting schema from a sql server database. It supports views, stored procedures, functions, tables, triggers and DDL triggers.

 …

Read More

Here are some thoughts on optimizing stored the performance of stored procedures.

In no particular order:

Clustered Indexes

Make sure your tables have clustered indexes.

It’s amazing to me that folks create tables without clustered indexes. A clustered index is …

Read More