Get all user tables with size
Returns User Tables by SIZE in DESCENDING ORDERAdd TOP n clause in SELECT to get selective results (i.e. TOP 10 TABLES)
2006-01-25 (first published: 2003-06-07)
2,426 reads
Kill All User Sessions
This script kills all the user sessions except its own.This T-SQL block can be converted into a stored procedure by adding following lines in the begining of the script - Create Proc Kill_Sessions As
2003-06-18
2,610 reads
Full String Search
This script will search a specified string in the current database and return all the tables with their columns containing that string. SET @search_str variable with the string to be searched (max. length allowed = 1000 chrs)
2003-06-07
403 reads
Blogs
Check Query Progress with Live Query Stats
This is something I touched on back in 2017 a little after the Live...
SQL Server 2019 on Docker no longer runs as root by default
In my home lab I have an Ubuntu virtual machine that runs both SQL...
SQL Server 2019 – Compatibility Level in Azure
By Arun Sirpal
I am not sure when this became available but for Azure SQL Database 150...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
SSIS catalog deployment from source server to target - powershell
I am looking for a good solution for automating the deployment of SSIS packages...
XML Data singleton value not fixed????
Hi Hope to explain this correctly I have some XML data that can vary...
Ask SSC