Knowledge Base
Search Results ...
SQL Server 2022: Built-in Query Hints for Stability
Welcome to SQLSupport.org, the forum where SQL Server enthusiasts, both budding and veteran, come together to explore the fascinating world of SQL Server. Today, we delve into the built-in query hints of SQL Server 2022, the big brother in the SQL Server f[.....]
SQL Server Dedicated SQL Pools vs Serverless
In the world of databases, SQL Server has long been a go-to solution for many organizations. With the release of SQL Server 2019, Microsoft introduced a slew of new features, including big data clusters and data virtualization. Alongside these, Azure SQL a[.....]
SQL Server Database Project Deployment with Azure DevOps
The integration of SQL Server Database Project with Azure DevOps has revolutionized the way we handle database operations. This fusion provides a seamless and efficient environment for managing and deploying your database projects. Let's explore this integ[.....]
SQL Server 2022: Enhanced Backup Compression
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
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
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
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
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
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
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[.....]