sql.sasquatch
Maybe ya seen my @sqL_handLe on the Twitter? :-)
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...
›
Home
View web version