Delete All Database User Accounts for a Given Server Login
Easily and quickly delete all database accounts even if they don't have the same name as server login.
2015-05-05 (first published: 2013-07-18)
5,456 reads
Find Stored Procedures and Functions That Reference Certain Tables
Find any code objects that interact with a given table/view, or call another given code object.
2015-04-10 (first published: 2013-07-05)
4,570 reads
Defrag All Indexes On a Database
Script to list out all fragmented indexes for a given database, with options to only view them, reorganize them, or rebuild them in one fell swoop.
2012-05-25 (first published: 2012-05-15)
2,671 reads
Blogs
Removing a Deleted Column from a Data Masker Masking Set
By Steve Jones
Data Masker for SQL Server is a great tool ensuring the data you use...
Containers: A Short Rant
I find myself doing more and more work with containers. Yet, I also find...
Daily Coping 20 Sep 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Metadata-Data-Ratio in a table
Hi all, My understanding about the structure of data within SQL Server is that...
Always On - why No failover occurred?
Hi, I am using SQL 2016 (13.0.5888.11). Last Saturday (18th September), in non-office hours,...
Log Shipping Truncate Log File
Good Morning, I have read that taking a log backup truncates the log file....
Ask SSC