sql complete

Find and delete incomplete open transactions in SQL Server – Part 3

In two previous articles, we have reviewed a solution for deleting incomplete open transactions in SQL Server. 

(more…)

Find and delete incomplete open transactions in SQL Server – Part 2

In the first part of the series of our articles on this subject, we presented the general algorithm for deleting open transactions that are not completed from a SQL Server database and considered the process of creating a table to record incomplete transactions. Now, let’s look at the process of creating a CRUD stored procedure to find and delete active transactions in SQL Server.

(more…)

How to create custom SQL Server replication for read-only databases

Quite often there’s a need to create a read-only replica of a SQL Server database. This might be required, for example, for the purpose of separating analytical and operative tasks. The first cause high load on databases and in order to reduce it, the replica of the primary database is created to perform analytical read-only queries. 

(more…)

Find and delete incomplete open transactions in SQL Server – Part 1

Frequently enough, MS SQL Server open transactions are incompleted and their initiators forget about them. This is quite a commonly encountered situation in routine database development. The most striking example is when one uses SQL Server Management Studio to run a script that starts an explicit transaction with the BEGIN TRANSACTION statement, but then the batch is canceled in the middle of a transaction without issuing a COMMIT or ROLLBACK statement to complete the transaction and the transaction is left open.

(more…)

Start debugging in SSMS with SQL Complete 6.4

The dbForge team is thrilled to present the latest version of SQL Complete for SQL Server. The most notable feature of this release addresses the newly introduced debugging functionality designed to take away the pain of combing through scripts to find errors and grant the possibility to debug T-SQL directly in the IDE. From now on, you don’t need to compromise on code quality.

(more…)

Get the most from your data with SQL Complete

Visualize your SQL data to facilitate understanding and decision making with the Data Visualizers feature of SQL Complete. On many occasions, developers and DBAs need to quickly check the table contents and getting data in a readable format without much effort becomes a matter of importance.

(more…)

New and redesigned formatting profiles in SQL Complete 6.3

At our users’ request, Devart introduces span-new formatting profiles that let you tune your SQL code like never before. Now you can not only format your code exactly as you want but also switch quickly to an alternative style or apply formatting specifically to certain parts of your SQL script if required.

(more…)

How to generate and use CRUD stored procedures in SQL Server

Most database systems operate on the basis of 4 simplest data manipulation operations that are called by the acronym CRUD. This acronym stands for Create, Read, Update, and Delete.

(more…)

Code Completion and SQL Code Navigation improved in SQL Complete v6.2

The dbForge team is excited to announce the release of a greatly enhanced SQL Complete v6.2. Being the flagman solution of the Devart company, SQL Complete is aimed at building consistency and quality into your code. This add-in for SSMS and VS will facilitate your database development, minimize downtime and help avoid performance issues.

The release addresses a number of major features and improvements.

(more…)

Execution history in SQL Complete

dbForge SQL Complete includes the whole range of options that provide possibilities for powerful optimization and great performance increase. Execution history is an important part of this list. It is included into the Standard and Express edition package. The feature stores basic information about executed SQL statements for a certain period. (more…)