#SQLPerformance

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

New article: SQL Server Join Estimation using Histogram Coarse Alignment #SQLServer #SQLPerformance #SQLblog

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

New #SQLPerformance article: Cardinality Estimation: Combining Density Statistics #SQLServer #SQLBlog

In his latest #SQLPerformance blog post, Glenn Berry (@GlennAlanBerry) goes over three different tactics you can use to squeeze extra performance out of SQL Server without a lot of heavy lifting.

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.

Did you know, the type of foreign key index you choose can cause blocking under RCSI, and update conflict errors under Snapshot Isolation? #SQLServer #SQLPerformance

7 indexing tips to improve #SQLServer performance: via @pinaldave #sqlperformance

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.

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

Importing data from a PDF file in #PowerBIDesktop with @rajendragupta16 #SQLPlan #SQLPerformance #PowerBI #Free

#SQLServer troubleshooting: Disk I/O problems with @esaterkec #SQLPerformance

#SQLServer Query recompilations and query performance effects with @esaterkec #SQLPerformance

[Blog] Happy 10th Birthday #SQLPerformance! I look back at my favorite posts across a decade. #sqlserver

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

Overview of Non-Clustered indexes in #SQLServer with @rajendragupta16 #SQLPerformance

AWS RDS #SQLServer – Monitoring database instances with @CherukuriRanga #SQLPerformance

New great article at @IDUGDb2 talking about #Db2 performance, explaining “early stage predicate evaluation” by Xiaohong Fu #sql #sqlperformance

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

Nice tip from @connor_mc_d use v$SQLSTATS instead of v$SQL. v$SQL can have huge performance impact on your running production system. #sqlPerformance #sqlAnalyzing #sql #apexconn19