Query Analytics

Name: Query Analytics
Works on: windows

Windows 2000 and above

Developer: DBAInABox

Version: 1.6
Last Updated: 26 Apr 2017
Release: 01 Aug 2013
Category: Programming > Coding languages and Compilers

Rate this software:
1029 downloads

View Screenshots(1)

Comments

Download

Liked it? Tell others:

Query Analytics Tags

Developers Editors

Query Analytics Details

Rating: 1.869565217 out of 5 based on 23 user ratings

Downloads: 1029
License: Free

Query Analytics is a free software by DBAInABox and works on Windows 10, Windows 8.1, Windows 8, Windows 7, Windows XP, Windows 2000, Windows 2003, Windows 2008, Windows Vista, Windows 2012.
You can download Query Analytics which is 1.37 MB in size and belongs to the software category Coding languages and Compilers.
Query Analytics was released on 2013-08-01 and last updated on our database on 2017-04-26 and is currently at version 1.6.

Thank you for downloading from SoftPaz! Your download should start any moment now. It would be great if you could rate and share:

Rate this software:
Share in your network:

Query Analytics Description

DIAB Query Analytics was designed to assist DBAs, and SQL developers with code review. It is a fast way to quickly scan a large script containing a mix of different objects. It is also an excellent SOX tool as it will quickly display code that may alter security. Although it will not parse the code, it will analyze the code for things that parsing does not see. Below is a short list.

1. Look for statements that will alter permissions, 2. Apply best practice rules of logic to the code, and identify poorly written statements. 3. Compare relations against each other and identify unequal data types and missing indexes. 4. Will identify Table and clustered index scans. 5. Will create a listing of all tables, columns, relational statements, and indexes found so you have quick access to most objects called within the script. 6. Will identify non-sargable code.7. Will display commands that will modify data. Use for deploying BI only code, or replication servers that should never be updated.