One Statement normally updates one target table in SQL Server. I use a transaction when two changes must succeed together.
SQL SERVER – sp_server_diagnostics – The User Does Not Have Permission to Perform this Action. (297)
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.
SQL SERVER – Master Database in Single User Mode – A Serious Issue
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.
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.