SQL Server Execution Plans

Posted by on April 12th, 2016

One of the best methods to analyze the query performance is to explore the query execution plan. A query plan or query execution plan is an ordered set of steps utilized to access data in a SQL relational database management system. In this article, we will discuss the basics of the Query Execution Plan feature available in SQL Server. (more…)

Using Oracle Optimizer Hints in Entity Framework

Posted by on January 23rd, 2012

With each new version of our Devart dotConnect for Oracle ADO.NET Entity Framework provider we pay special attention to improving its performance and configurability. It is pertinent to note some recent improvements: batch updates and flexible customization of Oracle Entity Framework provider behaviour. And now we are glad to present Oracle optimizer hints support in Entity Framework – a new feature for flexible tuning of SQL queries, generated by a user application.

Oracle Optimizer Hints

Oracle supports more than 60 different Oracle optimizer hints. You can see the complete list of Oracle optimizer hints and recommendations on their use in the Oracle Database documentation.

It is better to perform query optimization in external application, such as Devart dbForge Studio for Oracle, or any other tool for Oracle that you prefer. Queries, generated by Entity Framework, can be traced with dbMonitor and then copied and pasted to your SQL development application, where you can evaluate query performance, study execution plan, and choose optimizer hints to use. (more…)

New Features of Entity Framework Support in dotConnect Providers

Posted by on May 17th, 2011

In the new version of Devart dotConnect ADO.NET providers for Oracle, MySQL, PostgreSQL and SQLite we have significantly extended functional capabilities of Entity Framework. We maximally fulfilled requests of our users, including those received via our new UserVoice. Our users mainly requested new functional features, more flexibility in behavior and configuration as well as better performance.

Improving Performance for Parsing UNION Clause in SQL Complete

Posted by on December 27th, 2010

In the previous article we told that we’ve performed a lot of work concerning optimization of parsing queries in SQL documents. Also we informed that we’ve fixed all problems that were found by users of our intellisense… But recently one user sent us quite a small script that caused freezing of SSMS by Devart SQL Complete. Here it is:

Table-per-Type vs Table-per-Hierarchy Inheritance

Posted by on December 27th, 2010

In this article we will compare the performance of both most used inheritance types – Table-per-Hierarchy (TPH) and Table-per-Type (TPT), supported by LinqConnect starting from version 2.00. For a better understanding of these inheritance types, we will use the Model First approach when the object model is developed first and after that the database scheme is generated.

To develop an object model, the Entity Developer tool will be used.

Our tests are performed on the following object model:

We have a hierarchy of three entity classes: the base class Gadget and its descendants – MobilePhone and Netbook.

SQL Complete: Parsing performance improved!

Posted by on December 13th, 2010

Recently we have released a free SQL Complete tool that provides IntelliSense and script layout for SQL Server. If you like IntelliSense in Visual Studio and write T-SQL, you’ll probably appreciate the productivity improvements with SQL Complete.

Dare compare your data much more faster!

Posted by on May 11th, 2010

We compared some best-of-breed data comparison tools with dbForge Data Compare to find out which one is faster to compare and synchronize data in SQL Server databases.

The participant tools were tested with default settings on live databases on SQL Server 2008 that installed with default settings on a desktop (with a dual-core processor and 2Gb of RAM). Both the SQL Server and the SQL tools were installed on the same desktop.

Live Databases:
Two databases with total size of 1Gb: 115 tables containing one with 3 million records of numeric and string data types, the other with middle size BLOB data.

Task №1: We measured the speed of each tool while comparing the data, generating an update script, and at last synchronizing the databases.

Data Comparison/Synchronization Performance

Data Comparison/Synchronization Performance

Result №1: Tests results show that dbForge Data Compare for SQL Server v2.00 has leaved the competitors far behind.

Task №2: We decided to compare the performance of the selected participant tools based on the main industry-leading competitor’ performance. Besides we took into account the product price and tried to calculate the efficiency as best performance for less money.



Result №2: This graph shows that not all the tools can be proud of delivering an expected combination of best performance and best price. dbForge Data Compare handles this task well.

Check Shot

To fully complete our research, we decided to go the whole hog and use the aforementioned tools to compare large databases with the size of 120Gb (some tables in these databases have 2.4 billion records, some tables contain 1.5Gb of LOB data, the FILESTREAM table is with 5.3Gb of records). dbForge Data Compare was good at comparison, while neither of the competitive tools compared tables with LOB data and records in the FILESTREAM table. When we excluded such tables, only one tool coped with 2.4 billion records.
Speed rate of dbForge Data Compare is several times higher than other popular competitive tools have.

Try dbForge Data Compare on your database. Delivering qualitative data comparison and synchronization is our fame.

We guarantee quick support and product improvement if dbForge Data Compare fails to compare and synchronize your database. We even may give you the product license for free.

Moreover, you can take full advantage of data comparison and synchronization functionality in dbForge Compare Bundle that includes both dbForge Data Compare for SQL Server and dbForge Schema Compare for SQL Server, and also allows you to save money as compared to buying the tools separately.

We compared some best-of-breed comparison tools with dbForge Data Compare 2.00 to find out which one is speedier to compare and synchronize data in SQL Server databases.

The participant tools were tested with default settings on live databases on SQL Server 2008 that installed with default settings on a desktop with a dual-core processor and 2Gb of RAM. Both the SQL Server and the tools were installed on the same desktop.

Devart Delivers Performance-Leading SQL Comparison Tool – dbForge Data Compare 2.00

Posted by on April 29th, 2010

Devart announced the release of a new version of the professional tool for SQL server data comparison and synchronization – dbForge Data Compare 2.00. Committed to support the needs of database-dealing professionals, Devart now delivers a performance-leading SQL comparison tool that incorporates three times faster data comparison and synchronization, the smallest price and greater satisfaction than all other data comparison tools offer.

Incorporating these three components, dbForge Data Compare 2.00 guarantees greater satisfaction and smother database-dealing experience for any SQL comparison and synchronization goals.

The highlights of dbForge Data Compare 2.00 include:


dbForge Studio for MySQL v 3.60 – higher performance and new freedom in working with remote servers

Posted by on August 12th, 2009

Optimized tool facilitates database developers and web masters to efficiently work with remote databases at a lower cost with a greater speed.

Devart today announced the release of dbForge Studio for MySQL v 3.60, a cutting-edge tool for administration and development of MySQL databases.

The new upgrade is the contemporary answer for common bottlenecks originated from employing remote
MySQL Servers while developing, updating, and using modern large databases. dbForge Studio for MySQL v 3.60 offers new freedom for those who work with large schemas and data amounts especially in cases of using remote MySQL servers, for example serving web sites.