Query bottlenecks will be easy to find with this tool, as it allows viewing query execution statistics. After you apply improvements, you can compare the current statistics with the previous results to consider if your changes were effective.
Generate Script As
Generate template SQL SELECT, UPDATE, INSERT, DELETE scripts for tables from Database Explorer
Data export functionality to a CSV file
Use column separator: tab, space, custom
Bug fixes
Incorrect trial on Windows 8
Incorrect behaviour with identity columns on adding data in Data Editor
The navigation from the Error List to the specific error in a script
Exclude computed columns from synchronization by default
Error report when Estimated Rows exceeds the limits of integer in the Profiler document view
Error on changing connection in SQL document
Error on setting alias name in upper case
Improvement of work with memory while redirecting data to the Output window
Syntax error on executing the current statement using the Execute Current Statement command
Syntax error on executing a script with @@ variables
Issue with saving a file’s encoding
Issue with the installation of the product
Issue related to the focus, while executing several statements
Issue with highlighting of the IIF function
Issue in data editor with not assigning default values
Issue with clearing memory on selecting data from table
Issue with running the application on .NET Framework 4.5
Issue with removing a record in Data Editor
Issue with generating a schema name when exporting data using the MERGE mode
Issue with applying a filter in Data Editor
Issue with saving the Splitting options
Issue with changing options for code editor
Issue with connection to TFS 11
Issue with displaying the ‘Code Completion’ options
Issue with punctuation visibility in code editor with black background being set
OutOfMemoryException on searching data in Data Editor
ArgumentNullException on finding the next occurrence in text
ArgumentException on opening a file using the command line
SqlTypeException on executing a stored procedure with data entered out of the permissible range
FileNotFoundException on opening the New File window
NullReferenceException on editing data in Data Editor
NullReferenceException while working with a query that contains PIVOT (in Query Builder)
NullReferenceException on executing a query
NullReferenceException on editing a table in the editor
NullReferenceException on invoking Help in the Command Line
NullReferenceException on adding rows in Data Editor
NullReferenceException on retrieving data from the tables containing a BIGINT field
NullReferenceException on trying to find a search pattern in a document
NullReferenceException on executing a script
NullReferenceException on opening the SMTP options page
NullReferenceException on profiling a query
NullReferenceException on searching a text in a SQL document
NullReferenceException in Query Builder
NullReferenceException on creating a SELECT query in Query Builder
InvalidCastException on editing a subquery in Query Builder
InvalidCastException on double-clicking a table in Database Explorer
InvalidOperationException on executing a script
InvalidOperationException while executing queries on SQL Azure
InvalidOperationException on editing data in Data Editor
InvalidOperationException on refreshing data in Database Explorer
InvalidOperationException on closing a connection with invalid transaction