Knowledge Base

Search Results ...

SQL Server 2022: Enhanced Backup Compression

August 25, 2022 Posted by Tom Nonmacher

 

Welcome to SQLSupport.org! Today, we are thrilled to discuss the enhanced backup compression in SQL Server 2022. This feature represents a significant step forward in the SQL Server landscape, promising improved performance and cost savings. It builds on t[.....]

SQL Server Synapse Link Integration Examples

July 28, 2022 Posted by Tom Nonmacher

 

The buzz around SQL Server 2019, MySQL 8.0, DB2 11.5, Azure SQL, and Azure Synapse is well justified. The integration of these technologies, particularly SQL Server Synapse Link, can unlock a new level of data analysis and manipulation. This blog post will[.....]

SQL Server Memory Grant Feedback Explained

June 30, 2022 Posted by Tom Nonmacher

 

SQL Server 2019 introduced a new feature known as Memory Grant Feedback (MGF), which is part of the broader group of Adaptive Query Processing features. MGF adjusts the memory grant size for both batch and row mode operators, ensuring that the SQL Server e[.....]

SQL Server 2022: XML Compression Enhancements

June 9, 2022 Posted by Tom Nonmacher

 

SQL Server 2022 brings a host of new features and enhancements, including some notable improvements in XML compression. XML data can be quite verbose and lead to high storage requirements. Hence, enhanced XML compression techniques are crucial in managing[.....]

Monitoring TempDB Usage in SQL Server

May 19, 2022 Posted by Tom Nonmacher

 

Monitoring usage of the TempDB in SQL Server is crucial for database administrators. TempDB is a system database in SQL Server, which holds temporary user objects, internal objects, and version stores. It plays an essential role in SQL Server performance.[.....]

SQL Server Intelligent Query Processing Deep Dive

April 21, 2022 Posted by Tom Nonmacher

 

In the rapidly evolving world of database technology, SQL Server Intelligent Query Processing (IQP) has emerged as a game-changer. Introduced in SQL Server 2019, IQP has revolutionized the way queries are processed, optimized, and managed. This post will p[.....]

SQL Server Ledger Table Design for Immutable Records

March 24, 2022 Posted by Tom Nonmacher

 

The demand for immutable records has grown significantly in recent years due to the increase in data regulations and the need for data integrity. In this blog post, we will focus on designing a SQL Server Ledger Table to maintain immutable records. This de[.....]

SQL Server 2022: Parameter Sensitive Plan Optimization

February 24, 2022 Posted by Tom Nonmacher

 

SQL Server 2022 is here and it brings a host of powerful features, one of which is Parameter Sensitive Plan Optimization. This new feature assures the best possible query performance for your server by choosing the optimal execution plan based on the param[.....]

DB2 Federation Setup with SQL Server and Oracle

January 20, 2022 Posted by Tom Nonmacher

 

Federation setup in databases aims to create a unified data system from heterogeneous databases. Today, we will discuss the Federation setup between SQL Server, Oracle, and DB2. We will use the latest versions of these technologies: SQL Server 2019, MySQL[.....]

SQL Server 2022: Contained Availability Groups

January 6, 2022 Posted by Tom Nonmacher

 

Welcome to a new blog post from SQLSupport.org. Today, we will dive into SQL Server 2022 and explore the concept of Contained Availability Groups. Contained Availability Groups, an exciting feature introduced in SQL Server 2022, provide an enhanced level o[.....]





7FD620
Please enter the code from the image above in the box below.