4 тысяч подписчиков
350 видео
The Unpredictability Of SQL Server Performance
Defeating Parameter Sniffing With Dynamic SQL
SQL Server's sp_getapplock magic
UDF Inlining Demos
A Little About The OUTPUT Clause In SQL Server
A Little About Common Table Expressions In SQL Server
Making It Easy To Tell When Data Changed With Change Data Capture In SQL Server
Some Notes On Query Tuning With Batch Mode In SQL Server
A Little About How Overindexing Can Hurt SQL Server Performance
How I Set Up To Tune SQL Server Stored Procedures
A Little About Views, Parameters, and Local Variables in SQL Server
A Little About Select Queries That Cause Writes In SQL Server (Redux)
Performance Tuning GREATEST And LEAST Functions In SQL Server
A Little About How Indexes Store Data In SQL Server
How To Get Only Letters Or Numbers From A String For Free In SQL Server
A Little About Hash Aggregate Spills and SLEEP_TASK Waits In SQL Server
A Little About Intelligent Query Processing Limitations In SQL Server
A Follow Up On HT Waits, Row Mode, Batch Mode, and SQL Server Error 666
Stuff That Crashes SSMS 18.1
What’s The Point of 1 = (SELECT 1) In SQL Server Queries?
How SQL Server 2022's Parameter Sensitive Plan Feature Can Make Query Store Confusing
Hot Tips For Safer Dynamic SQL In SQL Server
How To Tell Which Queries Are Actually Doing Work In SQL Server Using sp_WhoIsActive
Building Reusable Queue Tables and Procedures In SQL Server
Check Constraints And Query Performance In SQL Server
Parameter Sniffing, Predicate Selectivity, And Index Key Column Order In SQL Server
The Best Way To Troubleshoot Slow SQL Server Queries
Inconsistent Error Handling By SQL Server
A Little About Improving Modification Query Performance In SQL Server
Profiling Query Performance In SQL Server With Extended Events The Easy Way
Table Variables in SQL Server 2019
Capturing and Analyzing Blocking with sp_HumanEvents
How To Fix Blocking In SQL Server With Better Indexes
How I Use sp_BlitzIndex To Find Indexing Problems In SQL Server Databases
A Little About Why ISNUMERIC Sucks In SQL Server
Rewriting Multi Statement Table Valued Functions
SQL Server 2017 CU 30 Doesn't Actually Fix The Problem With Views And Parameters
A Little About Memory Grants In SQL Server Query Plans
sp_QuickieStore: Time Zones, Time Zones, Time Zones
An Advanced SQL Server Query Profiling Technique
How Many Threads Can One Query Use In SQL Server?
How To Write SQL Server Queries Correctly: EXISTS and NOT EXISTS
So You Want To Implement Soft Deletes In SQL Server
IF Branching In SQL Server Stored Procedures: Dynamic SQL!
A Little About Locking And Isolation Levels In SQL Server
A Little About Filter Operators In SQL Server Query Plans
A Little About Out Of Date Statistics In SQL Server
How To Selectively Fire Triggers In SQL Server
A Very Silly Performance Tuning Trick In SQL Server
For The Last Time, It Doesn't Matter How Many Rows You're Putting In A Table Variable
All About SQL Server Stored Procedures: Error And Situation Handling
