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,427 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,615 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
406 reads
Blogs
New Pluralsight Course – Configuring and Managing Kubernetes Networking, Services, and Ingress
My new course “Configuring and Managing Kubernetes Networking, Services, and Ingress” is now available on Pluralsight here!...
Step By Step Installation of SQL Server 2019 with all features
By Rohit Garg
[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...
Step By Step Installation of SQL Server 2019 with all features
By Rohit Garg
[MSSQLFUN & Decote ITeS becomes a family of 1500 individuals across the globe. Please...
Forums
Career Advice: Data Warehouse Architect/Modeler
Maybe some of you would share your thoughts about my situation. I´m working in...
https //ketomegamar com/vaso-prime-rx/
Vaso Prime RX Now for your method. Process specific exercises that you perform on...
Avamar Backup--Is it good?
Dear Experts, is it good to use Avamar backup for SQL Server, currently we...
Ask SSC