Jason Givens


Technical Article

Get Table Sizes and Percent of Database Size

This script uses two undocumented stored procedures that retrieve all tables in the database in which it is run and lists the data and index sizes, the sum of these sizes, and the table's size percentage of the entire database. The results are presented in descending order of the sum of the data and index […]

5 (1)

2004-11-24 (first published: )

2,104 reads

Technical Article

Find Instances of a Column Name

This script will allow you to find all instances of a column name, or partial column name, in all user tables in the database in which it is run.  This is sometimes helpful during upgrades, etc.  There is no error checking in this script.  You can modify it to add, if needed.Run this by simply […]

5 (1)

2004-06-21

156 reads

Blogs

Tales From The Field Weekly Wrap Up for the Week of 01-31-2023

By

 Hello Dear Reader!  After a weekend with a lot of activities, it was a...

Creating a Flyway Desktop Shadow Database in PostgreSQL

By

In order to generate migrations, we need to configure Flyway to use a shadow...

Daily Coping 6 Feb 2023

By

Today’s coping tip is to get back in contact with an old friend. This...

Read the latest Blogs

Forums

Converting nested Json document to SQL data

By mandavli

I have response from a API that look like { "responseCode": 200, "message": "success",...

Converting nested Json document to SQL data

By mandavli

I have response from a API that look like { "responseCode": 200, "message": "success",...

To Drop or Not to Drop (the temp table question)

By Brandie Tarvin

So here's a thing that I've been told several times over the past few...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers