Diagnose PAGEIOLATCH_SH waits by comparing file read latency with Query Store physical reads before blaming storage or changing indexes.
SQL SERVER – Import CSV File into Database Table Using SSIS
How to import CSV file into database table using SSIS, step by step with images, so you can automate the load instead of running Bulk Insert by hand.
Designing a Load That Survives Failing Halfway
Build a restartable load with durable batch identity, transactional progress, repeatable input, and retries that do not duplicate business effects.
SQL SERVER – Resource Database ID – 32767
Why does DB_NAME(32767) return NULL? Resource Database ID 32767 belongs to the hidden Resource Database, which you will not find in sys.databases.
SQL SERVER – Common Table Expression (CTE) and Few Observation
A few observations on Common Table Expression (CTE): it does not replace temp tables, begin it with a semicolon, and its scope is one statement.
hierarchyid Ordering: Paths Follow Depth-First Order
hierarchyid ordering follows the hierarchy value. Sorting rendered path text can arrange numeric-looking components differently, so keep presentation text separate from traversal order.
SQL SERVER – What Kind of Lock WITH (NOLOCK) Hint Takes on Object?
What kind of lock does WITH (NOLOCK) take? Vinod Kumar made me think again: it takes a schema lock, and a quick query on sys.dm_tran_locks proves it.