#sqlPerformance

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

[Article] Looking at the internals of #SQLServer Grouped Aggregate Pushdown #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.

7 indexing tips to improve #SQLServer performance: via @pinaldave #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

SQL Server stats updated No more sluggish queries, just lightning-fast results! @CsharpCorner #SQLserver #DatabaseAdmin #SQLPerformance #tech #Database #SaturdayThoughts #developers #BusinessGrowth #goals

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

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

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.

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

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

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

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.

[Blog] : Are RID Lookups faster than Key Lookups? #sqlserver #TSQL2sday #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.

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 Plan 2018 R8 – Product update alert #SQLPlan #SQLPerformance #Free

[Blog] : Comparing string splitting / concatenation methods : #sqlserver #sqlperformance

#SQLServer monitoring tool for CPU performance #SQLPerformance

How to handle 100 million rows with #SQLServer BCP with @esaterkec #DatabaseMigration #SQLPerformance