Friday, May 26, 2023

performance

Is UNPIVOT the Best Way for Converting Columns into Rows?

To start, let's give definitions and highlight the difference between PIVOT and UNPIVOT operators in SQL Server. The PIVOT and UNPIVOT relational operators are used...

Fast and Simple Database App Development and Deployment to Linux in RAD Studio

The Devart company released UniDAC with support for Linux 64-bit platform. UniDAC makes application development and maintenance easier and simpler because the use of...

SQL Server Execution Plans

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...

What is faster inside SUM & AVG: 0 or NULL?

There are three aggregate functions that are most often used in practice: COUNT, SUM and AVG. The first one has already been discussed previously,...

How to reduce MSDB size from 42Gb to 200Mb

Recently I've got a spare minute to see why an old test server was running too slow... I had nothing to do with this,...

Increasing SQLite Performance

One the major issues a developer encounters when using the SQLite DBMS in his applications is its performance issue. Perhaps, a classic case everyone gets...

XML, XQuery & Performance Issues

In this article, we will discuss some pitfalls related to XML and XQuery that may lead to performance issues. The following code will generate a test...

What is the fastest way to calculate the record COUNT?

I have always liked simple questions with lots of pitfalls. Here is the one: how do you count the total number of records in...

SQL Server Typical Maintenance Plans: Automatic Statistics Update

Some time ago, we reviewed the automation of index defrag. Now, it is time to look at statistics. First of all, what do we need...

Instant File Initialization – Killer Feature for SQL Server

When SQL Server reserves new space on a disk, it initializes the space with zeros. This behavior can be switched off thereby reducing the...

Using Batch Updates in Delphi Data Access Components

Data amount processed by modern databases grows steadily. In this regard, there is an acute problem – database performance. Insert, Update and Delete operations have...

Capturing SQL Server Trace Data

One of the best ways to gather information about SQL Server workloads is to capture trace information. In this article, we will look at...

Analyzing SQL Server Events with help of Events Profiler

dbForge Studio for SQL Server provides the SQL Events Profiler tool that captures SQL Server events from a server. The events are stored in...

Adventures of CLR Types in .Net Framework

Summary: This article describes the issue occurred with execution of the a polygon instance of the geography type and the possible solution for it. Once...

Using Oracle Optimizer Hints in Entity Framework

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....

New Features of Entity Framework Support in dotConnect Providers

DML Options Batch Updates Batch Updates Limitations Batch Updates Settings Other DML Options SQL Formatting Settings Workarounds Database Script Generation Settings DeleteDatabaseBehaviour DBMS-Specific...

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

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...

SQL Complete: Parsing performance improved!

SQL Complete allows developers to use IntelliSense when they write SQL queries in SQL Server Management Studio. The tool will tell you the exact formatting you should use for your SQL commands while you are writing them and will therefore help you write fast, perfectly formatted SQL statements.

Dare Compare Your SQL Data Much Faster!

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

Social

Products