Free Downloads Center
e.g. SQL Inspect 1.1

Latest Reviews

Easy Time Logs Free

Easy Time Logs Free
Easy Time Logs Free, as the name suggests is an easy time tracking, timesheet and project management utility.

Eschelbacher Enterprises WebEditor

Eschelbacher Enterprises WebEditor
This amazing tool with its wizard capabilities allows you to make direct online changes to web pages and save them within no time.

Subscribe

SQL Inspect 1.1

Editor's rating  
Users' rating   (0 votes) Rate it!
License Shareware / $79.95
Downloads this week 144
Publisher Yohz Software
File size 3513K
Date added 25-Mar-2008
SQL Inspect screenshot

Enlarge screenshot

Publisher's description
Submit your review

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.

Visit homepage of SQL Inspect

Download SQL Inspect 1.1

sql table editor disk fragmentation compare tables defragment files query tools mysql queries audio record server advanced query tool gui sql oracle query

Programs related to SQL Inspect

Copyright © 2001-2007, Free Downloads Center.