Refreshing SQL … at a glance.

SQL SCRIPTS

Find my talk in Resources – SQL Relay 2014

These SQL scripts, created by our friendly development team for the PART system and only available to download here, just click on the title of the script you want to download. Please go to our link or the SQL Relay link for the PART system talk slides and further details on how these scripts may apply and be specifically of use to you.

These metrics are part of the preparation stage of our PART system and quickly locate and display some of the details that are necessary to measure the performance of the production system so it can be compared to the development or test systems giving a better idea of how your TSQL will perform on all of those systems.

The multi-use script for row generators, tally tables and number tables are just two examples that use row generators but there are many more examples of their use and they are one of the most effective mechanisms when optimising TSQL.

A nifty script here, comparisons make evaluating the changes (hopefully improvements) so much easier, use this to your advantage or share with a peer reviewing colleague for clarity. Essential to catch errors you may have inadvertently introduced when combined with well-prepared, controlled data sets.