Question: Why I am not able to KILL a SPID with command KILL (spid) WITH STATUSONLY?
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 – 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 – How to Install SSMS From Command Line? Error: The Specified Value for Setting ‘MEDIALAYOUT’ is Invalid.
There are many DBAs who like to automate the deployment of SQL. It is not fun to use wizard in all the installations. Imagine that setup media is kept in a remote share and all you need to do is provide a batch file to run and it would take care of installation. Let us learn How to Install SSMS From Command Line?
SQL SERVER – Observation – Adding a NULL Column and Table Space
It is always fun to receive a follow up comments when I write a blog post. Yesterday I wrote about SQL SERVER – Simple Query to List Size of the Table with Row Counts and here is the follow up question which I received about adding a NULL column.