FULL OUTER JOIN

https://www.w3schools.com/sql/sql_join_full.asp The FULL OUTER JOIN keyword returns all matching records from both tables whether the other table matches or not. So, if there are rows in “Customers” that do not have matches in “Orders”, or if there are rows in “Orders” that do not have matches in “Customers”, those rows will be listed as well.

Making Always On More Reliable

Increasing the Failover Maximum failures in a specified period will enhance the cluster service for making more attempts in keeping the role up and working. You can increase Maximum failures in a specified time period to 5 or more. Default is 2 in 6 hours. Failover Cluster Manager -> Roles -> click on resource ->... » read more

No Global Profile Is Configured

Error: No Global Profile Is Configured Resolution: 1.  Open database mail configuration by logging into SQL Server Management studio and expanding Management and right clicking on DatabaseMail, then choosing configure: 2.  Choose Manage Profile Security. 3.  Configure your profile to be the default profile: There’s no need to restart anything, your maintenance plan should now send... » read more