#SQLPerformance

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

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

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

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

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

Boosting SQL table performance is essential for lightning-fast queries! Try indexing, optimizing queries, and regular maintenance to keep your data running smoothly @CsharpCorner #SQLPerformance #DatabaseTips #Wednesdayvibe #SQLoptimization

New article: Simple Parameterization and Trivial Plans Shells, stubs, and two ways to avoid ad hoc plan cache bloat when client-side parameterization isn't feasible. #SQLPerformance

How to handle 100 million rows with #SQLServer BCP with @esaterkec #DatabaseMigration #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”

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

[Article] Eager to learn about lazy performance spools? #SQLServer #SQLPerformance

"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

Ever wonder what an Eager Index Spool does, or when the optimizer adds one to an execution plan? See my new post #SQLServer #SQLPerformance

[Article] ALTER COLUMN on fixed-length data types (e.g. int IDENTITY to bigint IDENTITY) can be an instant (metadata-only) operation for SQL Server 2016 onward: #SQLPerformance

T-SQL bugs, pitfalls and best practices – subqueries by @ItzikBenGan #SQLPerformance

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.

[Article] Concluding my three-part #SQLPerformance series on minimal logging with new details about the conditions required to achieve minimal logging when inserting to b-tree indexes with INSERT...SELECT #SQLBlog #SQLServer

[Article] Batch Mode Normalization and Performance #SQLServer #SQLPerformance

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