How to Derive the F Distribution
If you are unfamiliar with variable changes READ THIS PROOF! In it I derive the F Distribution probability function from the Chi-squared distribution.
How to Derive the F Distribution Read More »
December 2022
Tactics for Parallel Processing in TSQL
Learn the tools and tactics to stretch the functionality of SQL Server to the maximum and make parallel processing in TSQL a reality (even if you shouldn’t).
Tactics for Parallel Processing in TSQL Read More »
SQL Server Tip: Dynamic SQL Dummy References
Object dependencies are an important part of a supportable SQL Server DB. Dynamic SQL can obfuscate dependencies and require dummy references to correct.
SQL Server Tip: Dynamic SQL Dummy References Read More »