SQL InspectSQL Inspect collects the most commonly used information when tuning queries, and displays those information in an easy to use GUI. | |
Download |
SQL Inspect Ranking & Summary
Advertisement
- License:
- Free to try
- Price:
- $79.95
- Publisher Name:
- Yohz Ventures
- Publisher web site:
- Operating Systems:
- Windows 2000, Windows Vista, Windows XP
- File Size:
- 3.49MB
SQL Inspect Tags
- sql connection Improve sql editor manage database schema query optimizer getj xlight ftp server domus.cad 14.1.1 free limewire download postgres sql .m2v splitter animated moving desktop w3p to dvd iseries sql sql having sql 7 cd mri scan sql certification download inspect element orkut vista gadget
SQL Inspect Description
SQL Inspect is a SQL editor for SQL Server, created with the aim of allowing users to quickly analyze a sub-optimal query, the tables and indexes used by that query, and record all results of rewriting the query. It offers the following features over standard SQL editor tools: Get an overview of a querys' cost instantly - View a summary of the querys' I/O costs. - View execution plans in a treeview and see costly operations highlighted. - Know when statistics need updating, as differences in estimated and actual rows are highlighted. - See which tables are incurring the most reads. - Know when SQL Server is raising warnings when generating your execution plans. - Easily identify from which table each column is originating from. Know which tables and indexes are used in a query - Quickly know which tables are used in a query. - Know how big each of those tables are. - Also see which indexes are used, together with all indexes that exist for all tables used in the query. - Know the size and fragmentation level of each of those indexes. - Filter indexes to know which indexes cover or include a specific column. Compare your queries against a baseline query - Set a baseline query, and immediately see how your rewritten queries compare against the baseline. - Quickly know when your new queries are better than the baseline and when they are worse, and in which areas. Keep a log of your optimization attempts - Quickly know the costs of each query you have attempted in comparison to the baseline. - View the differences in how the queries were written. - Keep a record of each querys' execution plan. - Save the log for future analysis. View statistics and fragmentation information easily - The integrated object browser allows you to view details of all statistics for a table, together with table and index fragmentation details. - Integrated wizards help you to update statistics and defragment tables and indexes easily.
SQL Inspect Related Software