A client found the master database in single user mode, yet everything worked and switching back to MULTI_USER failed with Msg 5058. Here is the story.
SQL SERVER – FIX : Error: 3456, Severity: 21 – Could not redo log record (xx:xx:xx), for transaction ID (x:xx), on page (x:xx), database ‘master’
Could not redo log record in master, error 3456, and SQL Server would not start. How we rebuilt and recovered, and the backup that makes it simple.
SQL SERVER – How to Install SSMS From Command Line? Error: The Specified Value for Setting ‘MEDIALAYOUT’ is Invalid.
How to install SSMS from command line? A client’s silent install failed: the specified value for setting MEDIALAYOUT is invalid. Here is the fix.
SQL SERVER – xp_logininfo – Msg 15404: Could not obtain information about Windows NT group/user, error code 0x2147
xp_logininfo failed with Msg 15404 for some users, yet worked for the same user in another domain. Here is what to check to find the difference.
SQL SERVER – Unable to Change “Shared Feature Directory” Under Feature Selection
SQL Server 2014 setup would not let a reader change the Shared Feature Directory: the textbox and browse button were greyed out. The cause and the fix.
SQL SERVER – Observation – Adding a NULL Column and Table Space
Does adding a NULL Column with no default make a table bigger? Usually not. A reader’s question and a practical example that measures it.
SQL SERVER – Simple Query to List Size of the Table with Row Counts
A simple query I run at customer sites to list every table with its size in MB and Row Counts, including used and unused space.