#SQLPerformance

[Article] Looking at the internals of #SQLServer Grouped Aggregate Pushdown #SQLPerformance

In a new #SQLPerformance blog, Tim Radney (@tradney) talks about the performance trade-offs when deciding between various VM sizes in #Azure. #SQLServer

In a new #SQLPerformance blog, Paul White (@SQL_Kiwi) looks at the Eager Index Spool execution plan operator, and the optimizer rules capable of adding it into plans.

Struggling with costly recursive queries in SQL Server? Discover a solution to efficiently count employees for each manager in a company. #SQLPerformance #DataManagement

Improve #SQLServer transaction log performance with Delayed Durability with @esaterkec #SQLPerformance

Paul White (@SQL_Kiwi) goes deep on grouped aggregation pushdown in his latest #SQLPerformance blog post. He provides examples where this optimization is unsuccessful or simply not attempted, using the undocumented command DBCC CSINDEX. #SQLServer

Continuing his treatment of NULLs in #SQLServer, @ItzikBenGan takes to the #SQLPerformance blog to cover how SQL Server's implementation of unique constraints differs from the standard, and how you can work around it.

[Blog] : @SQLPoolBoy explains why predicate order in Extended Events matters : #sqlserver #sqlperformance #sqlskills

As a DBA, I can't stress the importance of regular SQL Server Performance Health Checks enough. Don't wait for issues to arise; proactively monitor and tune your SQL Server to ensure smooth operations and happy users. Trust me, it's worth the effort. #SQLPerformance

Since @ItzikBenGan is out of civilization today, I thought I’d tell you about his most recent #SQLPerformance article, “Fundamentals of Table Expressions, Part 11 – Views, Modification Considerations”

Monitoring activities using sp_WhoIsActive in #SQLServer with @HadiFadl2 #DBAtools #SQLPerformance #TSQL

[Blog] : Performance Myths : Oversizing string columns : #sqlserver #sqlperformance

Boost #SQLServer Performance with Wait Statistics with @esaterkec #SQLPerformance

[Blog] : Recently we needed to resolve an issue where forced parameterization negated a certain filtered index. There’s a solution that’s more elegant than you might have thought (it certainly surprised me): #sqlserver #sqlperformance

View Execution Plans in #AzureDataStudio with @rajendragupta16 #SQLPerformance #SQLPlan

#SSIS Expression Task Vs Evaluating variable as expression with @HadiFadl2 #SQLPerformance #ETL

Aaron Bertrand (@AaronBertrand) introduces Scalar UDF Inlining, a long-awaited feature in #SQLServer 2019 that will improve the performance of some workloads. #SQLPerformance

Boost your SQL table's performance with index optimization and query tuning! Learn how to make your data queries lightning fast. @CsharpCorner #SQLPerformance #DatabaseTips #Wednesdayvibe #database #SQLoptimization #developers #programming

#SQLPerformance blog guest author Dustin Dorsey shows how to prepare for a #CloudMigration to #AzureSQLDatabase by sending #SentryOne monitoring data to the DTU calculator.

[Blog] : @SQL_Kiwi rolls up his sleeves with the debugger to explain #SQLServer Sort internals : #SQLPerformance