#SQLPerformance

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

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

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

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

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.

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

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

[Blog] : @GlennAlanBerry talks about CPU choices for #SQLServer #SQL2014 : #sqlperformance #sqlskills

Hey NTSSUG members, check your email. You must be a member through @sqlpass to get this one. It contains a link and a secret code to access a special Eventbrite page for awesome, subsidized (low cost to you) #sqlperformance training by @chapmandew we are bringing to the group.

Explore the SQL query table hint READPAST with @rajendragupta16 #SQLPerformance

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

#SQLServer monitoring tool for CPU performance #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

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

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

How to resolve deadlocks in #SQLServer 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

ApexSQL Monitor – Screen shot tour #SQLMonitor #SQLPerformance