Sql Script Mover

January 13, 2017 jlion 0

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.


Faster Stored Procedures

January 2, 2017 jlion 0

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 the physical order of data in the table and it’s my understanding that it is difficult for SQL to reclaim …