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.
How to Insert Results of Stored Procedure into a Temporary Table? – Interview Question of the Week #124
How to insert results of stored procedure into a temporary table without creating the table first? Here is a simple script that shows the steps.
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.
SQL SERVER – How to Find Row Count of Every Table in Database Efficiently?
How do you find the row count of every table in a database without a cursor? An interview question, answered with a fast query instead of a loop.
SQL SERVER- Error: 18204, Severity: 16 – Backup Failure – Operating System Error 1240 (The Account is not Authorized to Log in From This Station)
A client’s backups to a file share failed at random with error 18204 and OS error 1240. The error message pointed to the real cause of this Backup Failure.