While working on Comprehensive Database Performance Health Check about additional transactional log files and today I got to follow up via email.
SQL SERVER – Multiple Log Files to Your Databases – Not Needed
I was asked a very interesting question by their DBA about log files. The question was – Is there ever need of multiple log files in SQL Server?
SQL SERVER – Fixing Freezing Activity Monitor
I personally prefer to use DMVs and DMFs but for the visualization easiness client preferred Activity Monitor which was Freezing suddenly.
SQL SERVER – SQL_NO_CACHE and OPTION (RECOMPILE)
How to retrieve queries, not from the cache for MySQL and SQL Server, we discussed SQL_NO_CACHE and OPTION (RECOMPILE). Let us discuss this.
SQL SERVER – Msg 1842 – The File Size, Max Size Cannot be Greater Than 2147483647 in Units of a Page Size
Could not allocate space for an object because the ‘PRIMARY’ filegroup is full and The File Size, Max Size Cannot be Greater Than 2147483647
SQL SERVER – Msg 17177 – This Instance of SQL Server Has Been Using a Process ID of %s since %s (local) %s (UTC)
In this blog today, I would share my understanding of the message “This instance of SQL Server has been using a process ID of”
SQL SERVER Management Studio – Rebuild All Indexes on Table
We are going to see a very simple trick about SQL SERVER Management Studio (SSMS), where we will learn how to rebuild all indexes.