User Tables with Size  all DBs (SQL 2005 Only)

Hope this is helpful to someone.  This script will create a table and a stored procedure in the master database to gather and store table info for all datbases. The sp uses a temp table to hold the results returned by sp_spaceused, then transfers the information to the permanent table DatabaseTableSizes and adds the database […]

5 (1)

2007-07-16 (first published: )

272 reads

Blogs

Blog .NET for Apache Spark UDFs Missing Shared State

By

The Problem When you use a UDF in .NET for Apache Spark, something like...

Migrating SQL Server container images to the Github Container Registry

By

A couple of months ago Docker announced that they would be implementing a 6...

Daily Coping 29 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

How to improve the performance of insert?delete?update sql statement

By 892717952

as it was said in the title, which we should pay attention to when...

TDE Drama

By Brandie Tarvin

My workplace uses a 3rd party key management system as an encryption provider for...

The Best Query

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Best Query

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Best Query

See possible answers