Quest SQL Optimiser validates database code to ensure the best-possible performance by helping you proactively identify potential issues and automate the SQL optimisation process. The SQL Server Query Optimizer is a cost-based optimizer. It analyzes a number of candidate execution plans for a given query, estimates the cost of each of these plans and selects the plan with the lowest cost of the choices considered. Indeed, given that the Query Optimizer cannot consider every possible plan for every query, it actually has to do a cost-based balancing act, considering both the cost of finding potential plans and the costs of plans themselves.

For SQL Server, Azure SQL Database, and Amazon RDS SQL Server, analyze the performance of databases and receive tuning recommendations for resolving them in minutes as opposed to hours. Target some of the most common areas of performance problems, such as queries, server configuration, security, database objects, memory, wait statistics, query plans, and much more.

SQL LDF Viewer Tool to Read & Analyze SQL Server Log File (.ldf) Transactions

Analyze SQL log file transactions & quickly perform SQL ldf file recovery
Preview .ldf Activity: Transaction, Time, Name, Table Name, & Query
Read & Analyze All Transactions like: INSERT, DELETE, UPDATE etc.
Supported Data Types: Datetime2, datetimeoffset, sql_variant, hierarchyid, geometry & geography data types.
Quick Scan, View LDF file and Auto locate associated MDF file
Provides support to fetch & view records from Live database
Recover Deleted Records if database is in Simple Recovery Mode.
Option to Filter & Export as SQL Database, as SQL Script or as CSV File
Provides Support to Analyze Multiple NDF File data
MDF File is required to analyze the database
The tool works both online & offline SQL database environment
Supported Unicode (collation) data tables after export
Supports SQL Server 2017, 2016, 2014, 2012, 2008 and SQL Server 2005 LDF Files

Oracle Code Factory is a premier Oracle GUI tool aimed at the SQL queries and scripts development. Key features include:

Visual Query Builder
Handy SQL Editor with code folding and syntax highlighting
Simultaneous executing of several queries with multi-threading
Data management: editing, grouping, sorting and filtering abilities
Data export to as many as 18 file formats
Data import from Excel, CSV, text files and more
Powerful BLOB Viewer/Editor

Tab Sessions make your work with tabs even easier. Each tab is saved periodically as defined by the interval for Window Content History. The two features are connected. You can also Restore Last Session by pressing the button on toolbar. This openes the last saved tabs already connected to the server they were connected too before. Simple, easy and fast.

SQL Log Analyzer tool allows user to connect to online SQL Server Database using proper credentials to automatically fetch the database & its records. This allows user to preview all the records within the database such as INSERT, UPDATE, DELETE etc.This inbuilt feature provides user to connect to Live Database for accessing the transaction logs.

DbSchema is a design tool for relational databases, with interactive diagrams, HTML documentation, Relational Data Browse and Editor, SQL Editor, Query Builder, Random Data Generator, Schema Compare and Synchronization, team work and more. Powerful, yet easy-to-use, DbSchema helps you design, document and manage databases without having to be a SQL pro. Easily design new tables, generate HTML5 documentation, explore and edit the database data, compare and synchronize the schema over multiple databases, edit and execute SQL, generate random data. DbSchema is compatible with all relational databases. It works on all major operating systems, including Windows, Linux and Mac.