Free Downloads Center
e.g. SQL Inspect 1.1

Latest Reviews

Free Address Book 1.2

Free Address Book 1.2
Free Address Book, an advanced tool that will store and organize your addresses, phone numbers, mobile, fax, and so on of your contacts and partners.

Anyplace Control

Anyplace Control
Anyplace Control is a multi-functional remote PC access software to remotely access and control any PC via LAN or Internet.

Subscribe

SQL Inspect 1.1 Download

Editor's rating  
Users' rating   (0 votes) Rate it!
License Shareware / $79.95
Downloads 367
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-2009, Free Downloads Center.