#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

In a new #SQLPerformance blog series, @ItzikBenGan discusses the fundamentals of table expressions, a commonly misunderstood feature in #TSQL.

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) explains in detail the factors #SQLServer considers when enabling minimal logging for inserts into a table without a clustered index.

[Article] Trigram Wildcard String Search in SQL Server #SQLServer #SQLPerformance

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

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

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”

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.

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

In his latest #SQLPerformance blog, Tim Radney (@tradney) shares some of the typical #SQLServer mishaps he comes across out in the wild, and resources you can use to avoid them in your own environments.

"Make it Faster: Myths about SQL Performance" – bei der APEX connect 2020 [Online] zeigte @dani_schnider, wie sich Performance-Probleme bereits bei der Entwicklung vermeiden lassen. Zur Aufzeichnung der Session: #APEXCONN20 #SQLPerformance

Execution Plans in #SQLServer with @avikoleum #SQLPerformance #SQLPlan #SSMS

SQL TOP statement #SQLPerformance tips with @esaterkec

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] : What to do (and not do) about top wait stats : #sqlserver #sqlperformance

Itzik Ben-Gan (@ItzikBenGan) resumes his #SQLPerformance blog series on T-SQL bugs, pitfalls, and best practices, treating an issue with correlated column references in subqueries.