A reader could not recycle ERRORLOG files with sp_cycle_errorlog. The ERRORLOG itself showed the reason. Here is what went wrong and how to fix it.
Performance Comparison EXCEPT vs NOT IN – Interview Question of the Week #095
EXCEPT vs NOT IN: which is faster? An attendee at PASS Summit asked me, and my simple example shows they work the same way and perform the same.
SQL SERVER – FIX Error: Maintenance plan scheduled but job is not running as per schedule
A maintenance plan was scheduled for 10 PM, but the job was not running as per schedule and showed no history. Here is how I found the cause.
SQL SERVER – Configuring Startup Options for SQL Server Management Studio
SSMS is the first thing I open every day. Here is how to configure the Startup Options in SQL Server Management Studio so it opens the way you work.
Error: Msg 1904 The statistics on table has 65 columns in key list
SQL SERVER – Fix: Error: Msg 1904 The statistics on table has 65 columns in the key list. Let us learn how to fix in this blog.
SQL SERVER – FIX Error 5120 – Database is in Read Only Mode After Attaching Files
An attached database showed read-only and SET READ_WRITE failed with OS error 5, Access is denied. Here is how to FIX Error 5120 with file permissions.
SQL SERVER – Displaying SQL Agent Jobs Running at a Specific Time
A client’s server froze every morning at the same time. The cause was a background job, so here is a query for displaying SQL Agent Jobs running at a set time.