In this blog, I would share my findings and Product Key for Developer Edition, Enterprise Evaluation Edition, and Express Edition.
SQL SERVER – Removing Additional Transactional Log Files
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 – 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?
State of Database Monitoring 2020 – Need Your Opinion
In 2018, Redgate launched the industry’s first-ever report into the state of SQL Server monitoring. Today we need your opinion.Â
Watch 7 SQL SERVER Courses FREE During Lockdown April 2020
Today we are going to see the learning path of 7 SQL SERVER Courses FREE which you should watch during this lockdown. All courses are free.
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.
Rebuild All Indexes for a Single Table – SQL in Sixty Seconds #086
Recently, while working with a client we ended up on a very interesting situation with a client where we had to Rebuild All Indexes for a Single Table.
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.
What is Stored in TempDB? – Interview Question of the Week #271
Question: What is Stored in TempDB?
Answer: In my recent conversation my client asked me if I know what is currently stored in their TempDb.