Is it possible that your statistics are many years old but still are valid? It is difficult to find Outdated Statistics is not as easy as it seems.
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.
Question: How to Capture Deleted Rows Without Trigger?
Answer: I was recently asked by my client during the Comprehensive Database Performance Health Check.
Enabling Priority Boost does not mean that you get performance from your SQL Server. It may be quite opposite. SQL in Sixty Seconds.
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.
Question: How to Change Database File Size?
Answer: By Shrinking the files. Now, many have a negative opinion about Shrinkfile.
Many sent me an email that they want to know more about the nested transactions. Let us learn about them in today’s blog post.