| T-SQL
Debugger
The
Debugger for Toad for SQL Server lets you code and debug the way
you work, line-by-line and statement-by-statement, without having
to change normal application execution or use cumbersome workarounds.
With Toad for SQL Server's Debugger, you can step through code one
line at a time as it executes on the server, set conditional breakpoints,
watch and modify variables, and view the execution stack. Included
in the Debugger is the Knowledge Xpert for SQL Server. The Knowledge
Xpert covers the lifecycle of SQL Server programming, offering a
wealth of technical knowledge, best practices and reusable examples.
Thousands of topics provide the background information, syntax and
working examples you need to apply solutions immediately.
Xpert
Tuning
The
Xpert Tuning module supplements SQL Server tuning skills for developers,
stepping up their application tuning capabilities. The Xpert Tuning
module makes observations about a selected SQL statement and the
underlying database environment, and then recommends several options
to improve performance. The AutoTune feature further automates the
tuning process by generating the SQL rewrites that offer the highest
likelihood of improving your SQL statement. In addition to offering
SQL tuning and schema change advice through the Xpert Tuning module,
a new Index Simulator emulates the effects of creating an index
with no impact to the target system. The new SQL Tuning component
shortens tuning time for developers and DBAs, while ensuring better
performing applications.
Quest
DBA Module
Users
can increase Toad for SQL Server's power and flexibility by adding
the Quest DBA module to automate day-to-day database management.
The integrated Quest DBA module provides a well-rounded environment
for DBAs and empowered developers to handle common administration
tasks such as quickly comparing and synchronizing database schemas,
servers, and data, This module also provides a feature to execute
across multiple databases via the Editor interface and an interface
to perform security migration across multiple servers. Included
in the Quest DBA Module is the Knowledge Xpert for SQL Server Administration
and T-SQL. The Knowledge Xpert for SQL Server Administration answers
70-80 percent of your daily SQL Server administration and T-SQL
questions instantly. Thousands of topics provide the background
information, syntax and working examples you need to apply solutions
immediately.
Benchmark
Factory® for SQL Server Developer's Edition
Users
can increase Toad for SQL Server's power and flexibility with Benchmark
Factory for SQL Server, to test user load on your SQL Server database.
The integrated add-on (optional) is a highly scalable load testing,
capacity planning and performance tuning tool. Benchmark Factory
for SQL Server allows users to determine system capacity, pinpoint
system bottlenecks and isolate system stress related problems in
your SQL Server environment.
QDesigner
PhysicalArchitect™
Physical
data modeling capabilities include SQL code generation, reverse
engineering of existing databases and enhanced data warehouse support
(PDM).
QDesigner
PhysicalArchitect™ with MetaWorks Repository
Physical
data modeling capabilities include SQL code generation, reverse
engineering of existing databases and enhanced data warehouse support
(PDM). |