Today we will see a very simple blog post about Adding Values Containing NULLs. During the consulting engagement of Health Check.
What is EDGE in SQL Server Execution Plan? – Interview Question of the Week #298
Question: What is EDGE in SQL Server Execution Plan?
Answer: It is the arrow or the line which goes from one operator to another operator.
5 Questions Answered OUTPUT Clause – SQL in Sixty Seconds #135
I have decided to create another SQL in Sixty Seconds video discussing the OUTPUT clause. In this video, we will discuss 5 questions.
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.
SQL SERVER – 7 Questions about OUTPUT Clause Answered
I got many questions from the users and I have listed them in today’s blog post. Let us discuss 5 Questions about the OUTPUT Clause Answered.
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.
SQL SERVER – Create Table From Another Table
One of the DBAs from the recently asked me if I know any easier way to create a table from another table without generating a CREATE TABLE script.
How to Capture Deleted Rows Without Trigger? – Interview Question of the Week #297
Question: How to Capture Deleted Rows Without Trigger?
Answer: I was recently asked by my client during the Comprehensive Database Performance Health Check.
Need Your Feedback – SQL in the Sixty Seconds Video – Oct, 2020
After reading all of them, I believe I should ask for your feedback as you have seen me blogging for so many years. Let me know what you think.