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)

You rated this post out of 5. Change rating

2004-11-24 (first published: )

2,326 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)

You rated this post out of 5. Change rating

2004-06-21

167 reads

Blogs

Implement a RAG Solution Using Azure SQL Database

By

AI and ChatGPT are all the rage these days.  Seems like around every corner...

2024 PASS Data Community Summit Prep

By

Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...

A New Word: Bye-over

By

bye-over – n.  the sheepish casual vibe between two people who’ve shred an emotional...

Read the latest Blogs

Forums

Cloud Sources for the Data Migration Assistant

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cloud Sources for the Data...

Your Personal ChatGPT Tutorial

By Kumar Abhishek

Comments posted to this topic are about the item Your Personal ChatGPT Tutorial

PASS Summit Time

By Louis Davidson (@drsql)

Comments posted to this topic are about the item PASS Summit Time

Visit the forum

Question of the Day

Cloud Sources for the Data Migration Assistant

Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)

See possible answers