Scripts

Technical Article

SQL Server Automated Backup & SAN Replication Solution

Script created by Syed Fahar Abbas. A Comprehensive Batch Script to: Verify/Request Administrator privileges and create a stable script copy. Grant NT AUTHORITY\SYSTEM database privileges and perform full SQL Server backup. Detect, or automatically download and silently install, WinRAR for compression. Compress the raw backup (.bak) into a high-compression RAR archive (.rar) and cleanup. Authenticate […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2026-09-29

199 reads

Technical Article

Server-Level Table sizes

This script creates a stored procedure that returns the following table size metrics in kilobytes, megabytes, and gigabytes for all tables in user-created databases (database ID > 4): Reserved space Used space Unused space Index size Data size

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-09-14

171 reads

Technical Article

Stored Procedures for Server-Level Object and Column Search

This script creates two stored procedures: One searches for the names of all user-created objects at the server level across all user-created databases (database ID > 4) based on a specified search expression. The other searches for column names in all user-created tables and views across all user-created databases (database ID > 4) based on […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-09-09

106 reads

Technical Article

Server-Level Row Counts for Tables and Views

This script creates a table that will store the row counts of non-system tables and views across all user-created databases (database ID > 4) on the server, as well as a stored procedure that refreshes the row counts by recalculating them. The script uses the database ServerInfo to store the table and stored procedure. Replace […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-09-04

133 reads

Technical Article

Demo Tracking Dropped Objects

This script demonstrates step by step how to implement a dropped objects tracking flow. Important limitation to consider: The stored state of a dropped object is based on the most recent available snapshot and not necessarily on the state of the object immediately before it was dropped. The accuracy of the stored information depends on […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-08-31

172 reads

Technical Article

Randomly Selecting Columns and Rows from a Table or View

The following script creates a procedure that returns a specified number of random columns and rows from a specified table or view. The number of columns and rows is determined by the @NumberOfColumns and @Rows parameters. The @RandomColumnOrder parameter specifies whether the selected columns are returned in random order or sorted by their ordinal position […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-08-31

129 reads

Technical Article

Column Data Types

This scripts creates a view containing data type information for columns in user-defined tables and views. It provides an overview of the data types in use and can help identify opportunities for data type optimization and standardization. The data types are formatted as they appear in Object Explorer in SSMS. For example, sysname is displayed […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-08-25

137 reads

Blogs

T-SQL Tuesday #204 – Are blogs still relevant? (Roundup)

By

I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...

Build vs Buy AI: When to adopt, partner, build or buy

By

Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...

What's New in SQL Server for the Developer: SQL Server 2012

By

Part 1 of my What's New in SQL Server for the Developer series. IIF,...

Read the latest Blogs

Forums

Switching Schema II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Switching Schema II

A Practical Approach to Automating SQL Server Email Notifications

By Kunal Rathi

Comments posted to this topic are about the item A Practical Approach to Automating...

Data Lost in the Cloud

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Data Lost in the Cloud

Visit the forum

Question of the Day

Switching Schema II

I run this query:

SELECT 
 s.name AS schemaname
 , o.name AS objectname
 FROM sys.objects o
 INNER JOIN sys.schemas s ON s.schema_id = o.schema_id
 WHERE o.name = 'Beer'
I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beer
What happens?

See possible answers