SteveStedman
TSQL Basics Part 14: FULL OUTER JOIN w/ exclusion – Video Explanation
This is part 14 “full outer JOIN with exclusion” of a 19 part series on TSQL Basics. You will first gain an understanding of the… Read More »TSQL Basics Part 14: FULL OUTER JOIN w/ exclusion – Video Explanation
Are You Using All Your CPU Cores
We recently worked on a SQL Server Performance Assessment for a client and during that we assisted with the upgrade from SQL Server standard edition… Read More »Are You Using All Your CPU Cores
In Observation
Any emails received this day will be answered the following day! Have fun and stay safe!
TSQL Basics Part 13: EQUI vs NON EQUI JOIN – Video Explanation
This is part 13 “equi JOIN vs non equi JOIN” of a 19 part series on TSQL Basics. You will first gain an understanding of… Read More »TSQL Basics Part 13: EQUI vs NON EQUI JOIN – Video Explanation
KeePass – to improve your process
Before proceeding with the article, please take this quick password safety test. Password Safety Test – Score one point for every YES answer.: Scoring: If… Read More »KeePass – to improve your process
TSQL Basics Part 12: OUTER APPLY – Video Explanation
This is part 12 of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these… Read More »TSQL Basics Part 12: OUTER APPLY – Video Explanation
SQL Server Memory Hog Query
The article could be named, “How to use up all of your SQL Server available memory with a single CTE query.” Another name for the… Read More »SQL Server Memory Hog Query
Raving fan June 2021
We contacted Steve when we were in desperate need of repair on a corrupted SQL database. After dealing with a couple of other vendors without… Read More »Raving fan June 2021
TSQL Basics Part 11: CROSS APPLY – Video Explanation
This is part 11 of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these… Read More »TSQL Basics Part 11: CROSS APPLY – Video Explanation