System Lock Snapshot

This script captures the current system lock in a temp table, then builds a temp translation table for database and object id by iterating through all of the databases.  It then produces a report by joining the two tables.For better performance, you could make the translation table perminante and only update it when you are […]

2002-06-14

551 reads

Blogs

Last Weeks Reading (2019-05-26)

By

It was tremendously extensive week for me (a week ago) when I spent time...

Migrating SSIS to Azure – Slidedeck (Techorama 2019)

By

Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...

Containers: Create a Custom Container

By

Creating a custom container is where things get truly exciting. There’s actually a ton...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Proverbial Tree Barking

By maverickuk82

Hi All, I'm just after a pointer really. I've had an idea. I want...

Transforming rows into columns

By rkarr7

Hi Everyone, I have a table with the structure as attached in the Table...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers