2016-11-29
1,142 reads
ANSI_NULLs
Get Your ANSI_NULLs Settings Consistent
William Talada brings us a short article to help you check your ANSI NULL settings and gives you a few reasons why you might want to make them consistent.
2010-01-27
7,448 reads
Blogs
SQLServerCarpenter Tools
Over the past couple of years, I’ve developed several tools that I’ve been using...
usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON
/* Author:Brahmanand Shukla (SQLServerCarpenter.com) Date:27-May-2022 Purpose:To get all the stored procedures and triggers missing the use of...
A New MVP Led Training Initiative – Cloud Formations
By Arun Sirpal
Hello Readers – I wanted to make sure those who follow my blog have...
Forums
SQL Server 2014 Question
So I have inherited an older SQL 2014 Server and have been working on...
Removing UNION and getting the same result
Hi, I need to update my sql script and remove the UNION but get...
SQL Server 2019 HA
Looking for a HA solution for SQL server for our branch offices. Current setup...
Ask SSC