#sqlperformance

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

[Article] Trigram Wildcard String Search in SQL Server #SQLServer #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”

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

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

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

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

A simple query rewrite that could save a lot of data being read #Oracle #sqlPerformance

Don't fear #SQLServer performance tuning with @esaterkec #SQLPerformance

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

Using Diskspd to test #SQLServer Storage Subsystems with @esaterkec #SQLPerformance

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

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

Scalar UDF Inlining in #SQLServer2019 with @esaterkec #SQLPerformance

#SQLServer monitoring tool for CPU performance #SQLPerformance

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

Using Automatic #SQLPlan Correction for Query Tuning with @esaterkec #SQLPerformance

SQL blocking chains in #SQLServer #SQLMonitor #SQLPerformance

[Blog] : Q & A from our Parameter Sniffing webinars with @KimberlyLTripp & @AndyMallon : @SentryOne #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