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,611 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
404 reads
Blogs
What the ???? T-SQL Tuesday #120
Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...
First Time Speaking at PASS Summit
By Bert Wagner
This week, I filmed my experience as a first time speaker at PASS Summit...
Azure SQL Best Practices?
By Arun Sirpal
A way to enforce good practice and standards is by Azure Policy. As stated...
Forums
Limiting the Data Frame
Comments posted to this topic are about the item Limiting the Data Frame
Micro Credentials
Comments posted to this topic are about the item Micro Credentials
CheckDB on VLDB, Geography data type
I've narrowed down a DBCC CheckDB issue to a set of tables with Geography...
Ask SSC