Question: How to Measure Page Splits Counter Value via T-SQL?
SQL SERVER – How to Update Two Tables in One Statement?
Question: How to Update Two Tables in One Statement?
SQL SERVER – sp_server_diagnostics – The User Does Not Have Permission to Perform this Action. (297)
In SQL Server 2012 onwards, the cluster health check detection logic has been enhanced. Instead of the traditional pull mechanism of the cluster (IsAlive and LooksAlive), SQL Server (version 2012 onwards) uses a push mechanism to detect the health of the SQL instance. This is done by special stored procedure called sp_server_diagnostics. We should remember that the failover mechanism for the AlwaysOn FCI and the AlwaysOn Availability Groups is same.
How to Round Up or Round Down Number in SQL Server? – Interview Question of the Week #125
Question: How to Round Up or Round Down Number in SQL Server?
SQL SERVER – AlwaysOn Join Error – Msg 1408, Level 16 – The Remote Copy of Database “SQLAUTH” is Not Recovered Far Enough to Enable Database Mirroring or to Join it to the Availability Group
I do provide consultancy services for deployments, including AlwaysOn availability group deployments. AlwaysOn Join Error.
SQL SERVER – Alternate to AGENT_DATETIME Function
Sometimes back I posted about interesting function AGENT_DATETIME functions which will convert integers into datetime values. Someone commented that there might be some permission issues using this function which is only available in msdb database. So I write this post to give you alternate method without using any such functions.
SQL SERVER – Master Database in Single User Mode – A Serious Issue
There are some weird situations which I see in SQL Server. This is also a one of the surprising situation. One of my client reported via below screen shot. Let us see the issue of Master Database in Single User Mode.