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

560 reads

Blogs

Daily Coping 18 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Optimize for Unknown for Inline Table-Valued Functions

By

I had a curious performance issue today. An inline table-valued function (iTVF) was performing...

Daily Coping 17 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SQL Query - FULL JOIN multiple tables but return NULL results

By glennyboy

Good day! Need help with my sql query code; first FULL JOIN "ILEtransfer" no...

Coping with a working life as an imposter

By Phil Factor

Comments posted to this topic are about the item Coping with a working life...

SQL Select with condition

By Dee Dee-422077

Hi, In my sql table,  there is a column which have string of text...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers