SQL Server Data Platform MVP 2011-2022
Latest articles:
- Recording Debugging Information Inside a SQL Server Function Call
- Accessing a SQL Server Table Variable in a Different Scope
- Avoid optional_spid Plan Cache Issues when Sharing Temp Tables
- Sharing Data Between Procedures using a Cursor
- Updating in Batches using an API Cursor
- Deleting in Batches using an API Cursor
- What Was the TOP PERCENT Bug and How Was It Fixed?
MERGEBug with Updates Though a View- How a Lazy Index Spool Works
- The SQL Server "Segment Apply" Optimizer Transformations
All articles available at sql.kiwi and paulwhite.nz
(including those originally published on SQLblog.com & SQLPerformance.com)
Select articles also available on
Find me on : @SQL_Kiwi
Email: paul@sql.kiwi
I will not respond to DBA site moderation questions off site. Use Database Administrators meta instead.