2017-05-01 (first published: 2017-04-19)
1,062 reads
Jason Givens
2017-01-30 (first published: 2017-01-26)
15,143 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,205 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
159 reads
Blogs
SQL Prompt Quick Access to Helper Code
By Steve Jones
We’ve been doing some events as part of the Redgate Roadshow, and at one...
Eleven chapters of my data architecture book are available
By James Serra
As I have mentioned in prior blog posts, I have been writing a data...
Speaking at SQL Saturday Boston 2023
By alevyinroc
I’m happy to announce that I will be speaking at SQL Saturday Boston on...
Forums
I can query one by one. Need help how to become Single Query
Hi, This is my table and data, CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_003]( [Id] [int] IDENTITY(1,1) NOT...
Baking up and restores VLDBs
Some of our databases are getting be close to 2 terabytes. We are backing...
Data Analysis with Python: Calculating Mean and Median
I'm working on a data analysis project in Python and need to calculate both...
Ask SSC