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 – Readers’ Opinion
Previously, I had written a blog post about SQL SERVER – Shrinking NDF and MDF Files – A Safe Operation. After that, I have written the following blog post that talks about the advantage and disadvantage of Shrinking and why one should not be Shrinking a file SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008. On this subject, SQL Server Expert Imran Mohammed left an excellent comment. I just feel that his comment is worth a big article itself. For everybody to read his wonderful explanation, I am posting this blog post here about Shrinking Database.
SQL SERVER – Get Last Running Query Based on SPID
We often need to find the last running query or based on SPID need to know which query was executed. SPID is returns sessions ID of the current user process. The acronym SPID comes from the name of its earlier version, Server Process ID. To know which sessions are running…
Read MoreSQL SERVER – Reseed Identity of Table – Table Missing Identity Values – Gap in Identity Column
Some time ago I was helping one of my Junior Developers who presented me with an interesting situation. He had a table with Identity Column. Because of some reasons he was compelled to delete few rows from the table. On inserting new rows in the table he noticed that the…
Read More