Understanding Outer Joins in SQL
The basics of outer joins are shown in this short piece that explains how they work.
2019-11-19
8,649 reads
jonfrisbee
How to Decipher @@Options
This article will show how you can read the @@OPTIONS variable and determine your settings.
2019-11-14
3,870 reads
2019-10-31
6,699 reads
Blogs
VMworld 2020 – Top 10 Database Sessions (Part 2)
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
Daily Coping 25 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
VMworld 2020 – Top 10 Database Sessions (Part 1)
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
Forums
Any guides for sizing Azure managed instances.
Hi All, Has anyone got any tips for sizing a move from VM running...
How to check if NextDay is Holiday (exclude Saturday and Sunday)?
Hi: We maintain a calendar table with these columns. We have a process which...
Always On - tips for running large transactions
Hi all, I wanted to get a second opinion on something, this weekend I...
Ask SSC