Question: Why I am not able to KILL a SPID with command KILL (spid) WITH STATUSONLY?
SQL SERVER – Installation Error – Status Code: 183 Description: Cannot Create a File When that File Already Exists
One of my client was unable to install SQL Server 2014 on a Windows 2012 Cluster. They were using mount points with below the structure. Let us learn about installation error.
SQL SERVER – Quickest Way to Add LoopBack Linked Server for OpenQuery
Here is the question which I received the other day from a user who was trying to add a linked server pointing its own server as he wanted to use OpenQuery. Let us read his question in details.
SQL SERVER – How to Measure Page Splits Counter Value via T-SQL?
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.