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.
Insert Multiple Values into Multiple Tables in a Single Statement – SQL in Sixty Seconds #132
It is totally possible to Insert Multiple Values into Multiple Tables in a Single Statement. Let us learn how we can do that in today’s video.
Priority Boost and Performance – SQL in Sixty Seconds #131
Enabling Priority Boost does not mean that you get performance from your SQL Server. It may be quite opposite. SQL in Sixty Seconds.
SSMS Efficiency – Replace STAR – SQL in Sixty Seconds #130
You might have heard that SELECT * is bad for queries performance. Let us learn in today’s video how we can replace STAR (*) by column name.
Cycle Clipboard Ring – SQL in Sixty Seconds #129
Copy (CTRL + C) and Paste (CTRL + V) are the friends of the DBAs and Developers. In SQL Server it is totally possible to use the Cycle Clipboard Ring.