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 »
Programming
Topics related to programming.
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 »
Linear Regression R Squared Formula
In part 4 of my series on linear regression the right way you will learn an alternative method to judge model accuracy: the linear regression R squared formula.
Linear Regression R Squared Formula Read More »
Linear Regression F Test of Model Variance
This post covers in detail the linear regression F test, the formulas for each component, how to derive them, and how to implement them in R.
Linear Regression F Test of Model Variance Read More »
Linear Regression T Test For Coefficients
In part 2 of this series on linear regression the right way you will learn how to perform, derive, and implement a regression T test for each coefficient.
Linear Regression T Test For Coefficients Read More »
Linear Regression Formula For Coefficients – The RIGHT WAY
Learn the linear regression formula THE RIGHT WAY! This post will show you the actual formula for estimating regression coefficients in its proper matrix form.
Linear Regression Formula For Coefficients – The RIGHT WAY Read More »