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,431 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,662 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
410 reads
Blogs
Why i use a smaller docker image part I
What is Docker? Docker is a famous platform for building, shipping, and running container...
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find...
SQL Server 2022 Administration Inside Out
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
Forums
Find specific string in column and retrieve text that follows it
I have a table contains 2 fields , objid and COMMENT as below: objid ...
SSIS Installation Issues
Hello all, I am attempting to install the SSIS package into VS2019 CE. I've...
SQL blocking caused by running ALTER VIEW script
Hello experts, One of our developers tried to alter a view and reported to...
Ask SSC