Show_Locks
Shows database, table names which are locked, the user who locks them, the command which is executed
2005-01-28 (first published: 2005-01-06)
1,121 reads
Where_Am_I
This SP takes a string to be searched as input parameter, loops through all tables, views, Sp-s in the database andreturns the name of the object it was found and number of occurences
2004-12-10 (first published: 2004-08-18)
637 reads
Script to DB Schema
This SP gets all the table names with the column names and data types, datalength. All the existing constrains on the table and column levels along with the Primary and foreign keys and table references
2004-06-01
225 reads
Blogs
Daily Coping 8 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Don’t be afraid of No
How many times have you been afraid to hear “No”? We have all been...
Spark .NET - Spark ML TF-IDF
By Ed Elliott
Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine...
Forums
How to do a Matrix properly
Hi everyone I have some events data with related delegates. The events have two...
DBCC CHECKDB output
I ran a DBCC on a database and it found some anomalies. Just looking...
Why is sys.master_files showing the size of RBS files as 0?
Dear Everyone I hope you are all safe in these strange times. I am...
Ask SSC