I often discuss this during Comprehensive Database Performance Health Check. Let us learn about how to Identify Table Creation Date from Traces.
NOCHECK CONSTRAINT: Loading Data and Trusting Foreign Keys Again
Use NOCHECK CONSTRAINT carefully, distinguish enabled from trusted foreign keys, validate old rows, and restore optimizer assumptions.
A Unique Constraint That Allows Many NULLs
Allow many NULLs while enforcing unique non-NULL values with a filtered SQL Server index, required SET options, and tested queries.
CLR Integration in SQL Server: When It Still Makes Sense
Review CLR integration uses, inventory existing assemblies, preserve strict security, and compare SQL Server 2025 built-in alternatives.
Filtering on a Window Function Without QUALIFY in SQL Server
Filter window results without QUALIFY using CTEs and derived tables, compare TOP WITH TIES, and preserve partition and tie rules.
SQL SERVER – Table Partitioning for Slow Performance
Something just conversation which I keep on doing again for ages. One of the conversations which never gets old is Table Partitioning for Slow Performance.
Snowflake – Query Result from Cache or Disk
Comprehensive Database Performance Health Check, The topic is how to identify on the Snowflake platform if the query result is from cache or disk.