SP to display locking users in tree format

This SP will give a listing of users blocking and being blocked in a tree formation (similar to explorer tree list). It uses a User defined function that recurses through the locking information gathered from sysprocesses. The listing only shows the Hostname (username) and the SPID.First create the User Defined Function (Part One) then create […]

2 (1)


2,030 reads


Altering a Computed Column in a Temporal Table in Azure SQL


System-versioned temporal tables were introduced in SQL Server 2016. They provide information about data...

Basic OFFSET–#SQLNewBlogger


Another post for me that is simple and hopefully serves as an example for...

Calgary Data User Group with Deborah Melkin and Andy Yun


Next week on Wednesday is the Calgary Data User Group’s second event for 2021,...

Read the latest Blogs


SQL2016 to Access2016 Linked server issue

By richardmgreen1

Hi all   We've got an issue with a linked server to an Access...

Future of SQL Server

By sean redmond

I am becoming a little disconcerted by the lack of news about the next...

Changing Data Drive Allocation Unit Size on Existing Installation

By garyb1

I have an existing SQL Server 2019 Standard installation that includes SSRS. The setup...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers