TSQL Script Explorer is a small utility that allows for the deconstruction of any valid TSQL script. Gather metrics such as, object counts, find non-fully qualified tables, list all the system functions used in a script, plus more…

Highlights: 

1. Count TSQL Object occurrences. ( i.e. DML statements, Tables, Joins, Variables, plus more.)
2. Ability to use different data sources to gather script metrics.
3. Output the results to .csv or tsv formats.
4. Simple TSQL Script formatting (Right click on the query window to bring up a context menu)
5. Fragmentize a script! Break apart a script into fragments.
6. Use the option to connect to a live SQL Server and gather metrics of currently executing TSQL!
7. Find tables inside a TSQL script that are not fully qualified.
8. Use the feature called "Counts Matrix" to see the complexity of your script.
9. DML Activity by Program, Login, Host and Database when you select the "Live" Data Source option.

Basic DML Count

Fragmentizing a TSQL Script



Download Now

Requires Free Registration

Please make sure to read http://www.ispysql.com/forumbridge/index.php?f=24&rb_v=viewforum

 This application is an ongoing project and should be considered a "Proof of Concept" application. It "CAN AND WILL" change without notice. 

* Available only when you select  "Live" as a source.
** Available only when use the "Server Object Tree" as the source.

Do you need something special? 
We can customize the TSQLAnalyzer.dll to suit your needs! One price, royalty free with multiple support options. For more information please email Robert Vallee at; This e-mail address is being protected from spambots. You need JavaScript enabled to view it


Version History:

v.2.3.9.0 (August-25-2010)

1. Fixed: Extract tables from Create\Alter\Drop Index Statements.

 v.2.3.8.0 (August-11-2010)

1. Fixed: Pivoted Table, Unpivoted Table, Variable Table, and Query Derived Table, are now counted as true Table Sources as well as their respective types.

v.2.3.7.0 (July-19-2010)

1. New Or Fixed in the Fragmentizer: Close Cursor Statement, Deallocate Cursor Statement, End Conversation Statement, ExecuteAs Statement, Fetch Cursor Statement, Label Statement, Open Cursor Statement, Revert Statement,Set RowCount Statement, Update Statistics Statement, UpdateText Statement, Use Statement, Set Statistics Statement, Send Statement.
2. Added: Shortcut to the SQL Server Registeration Window is F2
3. Added: Shortcut to the Options Window is F4
4. Added: Shortcut to Run a report is F5
5. Added: F6 will toggle the "Show Percentage Column Option" (Found under the Settings\Options Window)

v.2.3.6.0

1. Fixed: After running the report "DML Statement Count" and then running "DML Statements by Object, the values may be incorrect. This is due to the method ResetDMLCounters not being called.
2. New: Drag\Drop to Query window for files.
3. New: Options window. "Settings\Options", This window can only be accessed when a report is NOT running. Note: Only one option for now, Include percent column checkbox. Reason: When dealing with large amounts of data in the results grid, (i.e. Table Counts, String Literal Counts and TSQL Object Counts) not including the pct column will increase performance greatly.

v.2.3.5

1. Fixed: Now catching nested case expressions
2. Fixed: Double click results grid for table location when using the query window as a source.
3. Fixed: Set statements with subqueries were not finding any tables.

v.2.3.4.1

1. Fixed: Fragmentizer, (Which is used as the base for many of the features), The "When Statement" was not picking everything up.
2. Fixed: Insert, Update and Delete Statements were missing some tables.
3. New: You can now search for "Select *"

v.2.3.3.0

1. Fixed: AlterIndexStatement output includes both, Alter Index and the type of (Rebuild,Reorganize,Set,Disable)
2. Fixed: SQL Object List tree. Checking and Unchecking items from the right click menu was not working correctly
3. Added: Double click popup for, Server Object Tree\* Location\Results. Note; When the source is a job, double click is still buggy
4. Added: Percent of usage column to "Counts".
5. Changed: Columns, "start Offset is now "Start_Offset", "Fragment Length" is now "Fragment_Length"
6. Changed: Report Type names where changed to be more descriptive.
7. Changed: Report Type dropdown now is sorted.
8. New: Literal Location (Query Window & Server Object List)
9. New: Table Hint Location (Query Window & Server Object List)

v.2.3.2.0

1. Fixed: Live\DML Statements was generating an error about Non-Quailfied Table not having the correct column "Database"
2. Fixed: Extract GroupingSpecification, CreateEventSessionStatement and AlterEventSessionStatement were not being caught.
3. Passed: FXCOP 1.36 inspection.
4. Removed: Unused code.

v.2.3.1.0

1. Fixed: When running, Server Object Tree\Table Location\ across multiple datatabases, the action would run forever.

v.2.3.0.0

1. Fixed column order issue with Counts Matrix results.
2. Added 50 more TSQL Elements for the Fragmentizer.
3. Fixed: Results not clearing from grid upon next execute action.

v.2.2.1.0

1. Fixed Counts Matrix when run from the Server Object Tree. Values displayed were incorrect.
2. Removed the "Please Wait" splash.

v.2.2.0.0

1. Optimized the TSQLAnalyzer.dll (Again)
2. Added functionality DML Statement Breakdown, DML Statements, and Execute Statements to "Live"

v.2.1.0.0

1. Optimized the TSQLAnalyzer.dll
2. Removed some functionality
3. Cleanup UI code.

v.2.0.3.0

1. Added report to Query Window: Statement Extractor
2. Added report to Query Window: Fragmentize
3. Cleanup code.
4. Fixed bug with BinaryExpression errors.

v.2.0.1.0

1. Centralized exception handling. Any issues are written to the errorlog.txt file.
2. Fixed sporatic issues with right click on Server Object treeview.
3. Added a new report type, "DML Statements by Object" for the Server Object Tree
4. Improved performance.
5. Fixed double click errors when user double clicked on results grid. Some results have double click actions available