2017-06-16
1,871 reads
Jason Givens
2017-05-01 (first published: 2017-04-19)
833 reads
SQL Server Cluster Automatic Memory Management
Don't waste memory in a cluster! Learn how to allocate memory between instances.
2017-04-06
1,797 reads
2017-01-30 (first published: 2017-01-26)
10,101 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)
1,820 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
152 reads
Blogs
Career: Talk To References
By Steve Jones
As we try to get through these strange times in the world, I am...
Daily Coping 14 May 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
WIT Mental Health and Wellness Videos Posted
By Steve Jones
I was honored to speak at the WIT Mental Health and Wellness day last...
Forums
unable to deploy package unable integration service catalog
Hi I get teh following error while deploying package .NET Framework error occurred during...
Limit database restores to specific drive locations
As there isn't an option to use a DDL trigger on a RESTORE query,...
VLOOKUP Equivalent in SQL
Hi there I have two tables, one with an ID and Amount (Table 1)...
Ask SSC