Question: How to Add Constraint With No Validation?
Answer: I got this question from one of my clients of who is an Oracle user.
SQL SERVER – Identity and Constraint Confusion
What is going on with their server as I had no access to their data or schema. Let us learn about how identity and constraint confusion created problems.
SQL SERVER – Find Oldest Updated Statistics – Outdated Statistics
The word which they had used was Outdated Statistics. Let us learn more about it in today’s blog post. Find Oldest Updated Statistics
SQL SERVER – Adding Values Containing NULLs
Today we will see a very simple blog post about Adding Values Containing NULLs. During the consulting engagement of Health Check.
Multi Tables – 1 Drop Statement – SQL in Sixty Seconds #134
It was taking time as well as require to write them one at a time. In today’s blog post we will see how we can drop multiple tables with a 1 drop statement.Â
SQL SERVER 2019 – Performance Issues After Upgrading from SQL Server 2012
They reached out to me to help them fix their SQL Server Performance issues after upgrading. Comprehensive Database Performance Health Check.
Remove Trigger for Delete – SQL in Sixty Seconds #133
I am involved in the Comprehensive Database Performance Health Check. Today we will discuss how we can remove triggers for the Delete statement.Â