article thumbnail

Additional T-SQL Improvements in SQL Server 2022

SQL Performance

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. For example, suppose that prior to SQL Server 2022 you had the following query: SELECT. So far so good. FROM T1 INNER JOIN T2 ON T1.

Servers 142
article thumbnail

String Aggregation Over the Years in SQL Server

SQL Performance

Since SQL Server 2005, the trick of using FOR XML PATH to denormalize strings and combine them into a single (usually comma-separated) list has been very popular. In the SQL Server 2005 days, I would have offered this solution: SELECT DISTINCT UserID , Bands =. ( 1 Pink Floyd, New Order, The Hip 2 Zamfir, ABBA.

Servers 82
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Get details of SQL Server Database Growth and Shrink Events

SQL Shack

It is essential for the DBA to need to ensure the SQL Server database performance. Overview of Default trace in SQL Server Starting from SQL Server 2005, SQL Server captures a few critical events in the default traces. […].

article thumbnail

Refreshing SQL Server Tables With Less Interruption Using Partition Switching

SQL Performance

A common requirement in ETL and various reporting scenarios is to quietly load a SQL Server staging table in the background, so users querying the data aren’t impacted by the writes and vice-versa. Refreshing Tables in SQL Server. SQL Server Partition Switching Example. Compared to the Old Way of SQL Server Partition Switching.

Servers 55
article thumbnail

Observability platform vs. observability tools

Dynatrace

For example, in 2005, Dynatrace introduced a distributed tracing tool that allowed developers to implement local tracing and debugging. A database could start executing a storage management process that consumes database server resources. The case for an integrated observability platform.

article thumbnail

Does SQL Server 2016 Require Trace Flag -T8048?

SQL Server According to Bob

Prior to SQL Server 2016 the trace flag –T8048 is used to upgrade (only) NUMA partitioned, CMemThread objects to CPU partitioned based objects. Keep in mind that the vast majority of CMemThread objects (SQL 2005, 2008, 2008 R2, 2012, 2014, Azure DB and 2016) are not partitioned. Trace flag –T8048 longer exists in SQL Server 2016.

Servers 40
article thumbnail

It’s time to migrate from NAM to Dynatrace

Dynatrace

It evolved from the simplest web server plugins to runtime Java profilers to real-time performance monitoring of all transactions flowing end to end through application servers. The market grew tremendously, fueled by the adoption of the Java platform as the application server standard. .” The AppMon wave.

Network 167