Question: Is there any way to replace DBCC INPUTBUFFER Command?
SQL SERVER 2016 – DBCC Command Enhancement with MAXDOP
When you want to be successful, you need to run alone and fast. But if you want to run longer, you want to run together. I have personally seen multiple instances where this statement holds true to every word. When working with customers and in various consulting engagements, I have seen it is not enough to just solve the problem. It is important to enable the team working on the project and make them aware of the reasons why it did happen in the first place. I always felt the art of working together will take us a long way. Even in performance engagements, I try to get the team involved as I go through the process of solving their problems. Let us learn in this blog post DBCC Command Enhancement with MAXDOP.
Identify Used Space in Log File- Interview Question of the Week #090
Question: How to identify Used Space in Log File?
Answer: Use following command to display used log file size and total used space in the log file.
SQL SERVER – What is DBCC TRACEON and DBCC TRACEOFF messages in ERRORLOG?
One of my clients asked me more about these messages logged in the SQL Server ERRORLOG. If you are new to SQL Server and don’t know how to reach to ERRORLOG, read below Where is ERRORLOG? Various Ways to Find ERRORLOG Location. In this blog post we will discuss about DBCC TRACEON.
Interview Question of the Week #033 – How to Invalidate Procedure Cache of SQL Server?
Question: How to Invalidate Procedure Cache in SQL Server?
SQL SERVER – Shrinking Database is Bad – Increases Fragmentation – Reduces Performance
Earlier, I had written two articles related to Shrinking Database. I wrote about why Shrinking Database is not good.
SQL SERVER – Shrinking Database NDF and MDF Files
Previously, I had written a blog post about SQL SERVER. I am posting this blog post here about Shrinking Database.