# General Questions regarding Toad SQL

**URL:** <https://forums.toadworld.com/t/general-questions-regarding-toad-sql/52535>\
**Category:** Toad for SQL Server\
**Created:** [April 1, 2021, 10:55am UTC](https://forums.toadworld.com/t/general-questions-regarding-toad-sql/52535 "2021-04-01T10:55:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sultanam99](https://avatars.discourse-cdn.com/v4/letter/s/ecb155/32.png) [@sultanam99](https://forums.toadworld.com/u/sultanam99)\
**Post date:** [April 1, 2021, 10:55am UTC](https://forums.toadworld.com/t/general-questions-regarding-toad-sql/52535/1 "2021-04-01T10:55:42Z")

</div>

How does it store its data? (e.g., in-memory database vs on drive)  
What indexes does it support?  
Is it relational or non-relational?  
Does it support ACID properties?  
how does it handle concurrency control?  
how does it handle recovery and logging?  
Explain what workloads do you think it should be used for (and why)? (OLAP? OLTP? ...etc)  
What are its pros? its cons?

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [April 1, 2021, 6:26pm UTC](https://forums.toadworld.com/t/general-questions-regarding-toad-sql/52535/2 "2021-04-01T18:26:05Z")

</div>

Toad for SQL Server is a client IDE that facilitates working with SQL Server, whether you're a DBA, developer, or even a data analyst, all can use the product to extract and work with the SQL Server database.

All of your questions are asked in the context of the database, not of Toad. e.g. Toad is neither relational nor non-relational, since it is not a database. Toad works with your SQL Server database, so that you can manage data, indexes, tables, procedural code, debug, tune SQL queries, compare and sync schemas and data, etc. etc.

For more info, see...

> **[SQL Server Database Management Tools | Toad for SQL Server](https://www.quest.com/products/toad-for-sql-server/)**
>
> Discover how Toad for SQL Server software helps you accelerate productivity for faster, more reliable databases. Easily manage multiple SQL Server databases.

> **[Toad for SQL Server](https://www.toadworld.com/products/toad-for-sql-server)**
>
> Toad for SQL Server product page. Increased productivity for SQL Server development and administration