While working on Comprehensive Database Performance Health Check about additional transactional log files and today I got to follow up via email.
How to Solve Error When Transaction Log Gets Full? – Interview Question of the Week #272
Question: How to Solve Error When Transaction Log Gets Full?
Answer: This was a question I was asked in the recent Health Check.
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 – Top Reasons for Slow Performance
Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. Let us discuss this topic today.
SQL SERVER – Find the Growth Size for All files in All Databases – Part 2
A few years ago, I had written a blog post Find the Growth Size for All files in All Databases. Today, we will post a small correction to it.