Latish Sehgal's Blog

SqlSmash V2: Faster and Better

Last week I released SqlSmash v2.0. The primary focus of this update was performance improvements. With version 1, there were a few users (with tens of thousands of objects in their SQL Server databases), for whom the plugin was too slow to be useable. I had to rewrite a lot of the core code to address this, but I am really happy with the results. There is more than 100X speed and memory improvements as far as the initial cache building is concerned. Searching for objects is also much more faster and efficient than before.

The following new features have been added:

See Related Data for Grid Results

Use foreign key relationships to bring back data from other tables related to the one in your results grid. This improves ad-hoc querying when you’ve got a long chain of related tables.

Tab and Query Execution History

Access your recently opened Tabs and Executed Queries, even if you did not save the file locally.

Generate Insert Statements

Generate Insert Statements for any data in your results grid. This can be very handy when you need to move data quickly between different tables across databases or servers.

Data Protection

Get a warning if you are running a Delete or Update statement without a Where clause.

Increase/Decrease Selection

Increase the selected text quickly to the logical parent of the current selection.

In addition to the above, several existing features have been improved:
* You can now go straight to the Object Definition from the “Goto Object” Window or the “Find References” popup. Just press Shift + Enter instead of pressing Enter. Pressing Enter in those lists still takes you to that object in Object Explorer.
* You can select your object under cursor in Object Explorer now by using the “Locate in Explorer” menu item (or pressing Alt + F12).
* You can filter the results of the Summary/Navigation Window now.

Here’s a short screencast showing the different SqlSmash features. If you have any feedback, feel free to leave a comment below or reach out to me on twitter.