2017-05-01 (first published: 2017-04-19)
1,122 reads
Jason Givens
2017-01-30 (first published: 2017-01-26)
17,513 reads
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 […]
2004-11-24 (first published: 2004-10-25)
2,314 reads
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 […]
2004-06-21
166 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
Impact of adding the opening of the Master Key in a SQL job for SSIS packages
Bonjour à tous, J'ai un problème d'exécution de mes packages SSIS. A chaque opération...
Being an extroverted introvert at a conference
Comments posted to this topic are about the item Being an extroverted introvert at...
Need to group the same valued ID fields to run an aggregate average over them
I have data that contains poll results, with the poll_id consistuting a single row...
Question of the Day
How are statistics stored?
How are the statistics for query optimization stored in SQL Server?
See possible answers