Everything you care about in one place
Follow feeds: blogs, news, RSS and more. An effortless way to read and digest content of your choice.
Get Feeder
sql-sasquatch.blogspot.com
sql.sasquatch
Get the latest updates from sql.sasquatch directly as they happen.
Follow now 14 followers
Latest posts
Last updated over 3 years ago
Big-Big #SQLServer Table Migration via bcp (echoes of Friday, February 8, 2013)
over 3 years ago
Today (2023 March 10) I am having memories of helping with bcp...
#SQLServer - USE HINT ('DISABLE_OPTIMIZER_ROWGOAL') - SURPRISE! TOP operator in graphical query plan
over 3 years ago
Hello!!! Sometimes perhaps the things I care about will really leave people...
Let's check up on the SQL Server transaction log buffers in SQL Server 2019 CU 16!!!
almost 4 years ago
I'm looking into a severe LOGFLUSHQ spinlock issue in SQL Server 2019...
SQL Server - recursive CTE to retrieve rowstore index IAM chain
over 4 years ago
A SQL Server recursive CTE can reach a maximum level of recursion...
SQL Server - recursive CTE to retrieve dependency chain of Resource Governor Classifier Function
over 4 years ago
SQL Server Resource Governor classifier functions can include references to functions as...
#SQLServer Trivial Plans for Inserts; Stats Expectations and Reality
over 4 years ago
OK. SQL Server trivial plans for rowstore table INSERT. And related optimizer...
#SQLServer - Database Cache Suppression
almost 5 years ago
Third blog post in a quick series about potential trouble at the...
#SQLServer Database Cache Memory Magic at SQLOS Node Level -- Chaotic or Even A Little Bit Sinister
almost 5 years ago
This blog post continues to look at a topic I blogged about...
#SQLServer Column Store Object Pool -- the Houdini Memory Broker Clerk AND Perfmon [\SQLServer\Buffer Manager\Target pages]
almost 5 years ago
Howdy!I use perfmon a lot for SQL Server stuff :-)Have you ever...
#SQLServer: There's Something About SQLOS Memory Node Free Memory on NUMA systems...
about 5 years ago
In 2018 I wrote two blog posts about memory accounting behavior on...
#SQLServer Snapshot Isolation Level - increase query CPU time and elapsed time by a factor of 8!
about 5 years ago
OK. This is a little test in my SQL Server 2019 CU11...