An AlwaysOn resource would not come online, and the cluster log showed sp_server_diagnostics failing with error 297, no permission. Here is the fix.
How to Round Up or Round Down Number in SQL Server? – Interview Question of the Week #125
How do you round up or round down a number in SQL Server? A quick answer using ROUND, CEILING and FLOOR, and how each one behaves.
SQL SERVER – Alternate to AGENT_DATETIME Function
This Alternate to AGENT_DATETIME converts integer date and time values without calling an msdb function. I preserve leading zeros in the time.
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 – 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.







