SQL optimization

Understanding CROSS APPLY and OUTER APPLY in SQL Server

Introduction When working with table-valued functions (TVFs) or subqueries, the CROSS APPLY and OUTER APPLY operators provide flexible […]

 dans Sites anglophones  étiqueté cross apply / INNER JOIN / left join / OUTER APPLY / SQL Basics / SQL Function / SQL Join / SQL optimization / SQL Performance / SQL programming / SQL Queries / SQL Query Examples / SQL Server / SQL Subquery / SQL tutorial / t-sql / Table-Valued Functions / TVF par

Improving the Performance of UPDATE Statements in SQL Server

Introduction Performing bulk updates in SQL Server can be a resource-intensive operation, particularly when dealing with large datasets. […]

 dans Sites anglophones  étiqueté batch size / batch update / bulk update / CPU usage / database management / Database Performance / disk I/O / execution time / large datasets / locking contention / memory usage / performance analysis / performance metrics / query optimization / row-by-row update / SQL optimization / SQL Performance / SQL Server / SQL Server tuning / SQL Server update operations / SQL testing / system resources / t-sql par

Understanding SQL Server LEFT_SHIFT and RIGHT_SHIFT Functions

Introduction SQL Server 2022 introduced the LEFT_SHIFT and RIGHT_SHIFT functions, which allow you to manipulate numbers by shifting […]

 dans Sites anglophones  étiqueté binary operations / bitwise operations / bitwise operations in SQL Server / bitwise shift / bitwise shift examples / data manipulation / date expressions in SQL / LEFT_SHIFT / RIGHT_SHIFT / Sql Functions / SQL optimization / SQL Server / SQL Server 2022 / t-sql par