#SQLPerformance

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

In a new #SQLPerformance blog series, @ItzikBenGan discusses the fundamentals of table expressions, a commonly misunderstood feature in #TSQL.

[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

Monitoring activities using sp_WhoIsActive in #SQLServer with @HadiFadl2 #DBAtools #SQLPerformance #TSQL

Top five considerations for #SQLServer index design with @AhmadZYaseen #SQLPerformance

How to detect and prevent unexpected growth of the TempDB database with @ahmadzyaseen #SQLPerformance

Enjoying every bit. Recording some videos on SQL Server Internals and Performance Tuning. Watch them on SQLMaestros YouTube channel: #sqlserver #sqlinternals #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] Trigram Wildcard String Search in SQL Server #SQLServer #SQLPerformance

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

[Blog] : Some insight into the new #sqlperformance . com design :

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”

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

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

Top things you need in a SQL Server performance monitoring tool (from deadlocks monitoring to alerting and index monitoring) #SQLServer #SQLPerformance #sqlindex #sqltuning via @ApexSQL

New great article at @IDUGDb2 talking about #Db2 performance, explaining “early stage predicate evaluation” by Xiaohong Fu #sql #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.

Article: New details about "Minimal Logging with INSERT…SELECT into Heap Tables" #SQLServer #SQLBlog #SQLPerformance

Aaron Bertrand (@AaronBertrand) introduces Scalar UDF Inlining, a long-awaited feature in #SQLServer 2019 that will improve the performance of some workloads. #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.