#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

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.

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.

ApexSQL BI Monitor 2018 R7 - Product update alert #BIMonitor #SQLMonitor #SQLPerformance #SSIS #SSAS #SSRS

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

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

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

ApexSQL Monitor – Screen shot tour #SQLMonitor #SQLPerformance

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

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

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

Importance of #SQLServer Max Degree of Parallelism #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

SQL Connection Strings tips with @esaterkec #SQLServer #SQLPerformance

Resolve and Troubleshoot #SQLServer Blocking chain with root session #SQLPerformance

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

Impact of the Column order in Composite Index #SQLServer with @rajendragupta16 #SQLPerformance