Friday, March 10, 2023

Big-Big #SQLServer Table Migration via bcp (echoes of Friday, February 8, 2013)

›
Today (2023 March 10) I am having memories of helping with bcp from one SQL Server 2008 R2 database to another of a 9.5 billion+ row table b...
Tuesday, January 31, 2023

#SQLServer - USE HINT ('DISABLE_OPTIMIZER_ROWGOAL') - SURPRISE! TOP operator in graphical query plan

›
 Hello!!!  Sometimes perhaps the things I care about will really leave people wondering. :-) In this case, it's a SQL Server graphical q...
1 comment:
Thursday, December 8, 2022

Let's check up on the SQL Server transaction log buffers in SQL Server 2019 CU 16!!!

›
 I'm looking into a severe LOGFLUSHQ spinlock issue in SQL Server 2019 CU16. The issue first presented itself afaik in CU 15. I'll p...
Monday, April 4, 2022

SQL Server - recursive CTE to retrieve dependency chain of Resource Governor Classifier Function

›
SQL Server Resource Governor classifier functions can include references to functions as well as tables in the master database.  And each re...

SQL Server - recursive CTE to retrieve rowstore index IAM chain

›
 A SQL Server recursive CTE can reach a maximum level of recursion of 32768. Strting with the first IAM page for a rowstore index, the entir...
Monday, February 28, 2022

#SQLServer Trivial Plans for Inserts; Stats Expectations and Reality

›
OK.  SQL Server trivial plans for rowstore table INSERT. And related optimizer stats interaction. TL;DR cached trivial plans for INSERT can ...
Tuesday, December 7, 2021

#SQLServer - Database Cache Suppression

›
Third blog post in a quick series about potential trouble at the high AND low side of [\SQLServer:Buffer Manager\Target pages].  So far I...