2017-06-16
1,886 reads
Jason Givens
2017-05-01 (first published: 2017-04-19)
875 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,908 reads
2017-01-30 (first published: 2017-01-26)
10,656 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,852 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
153 reads
Blogs
Daily Coping 5 Aug 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Interview Tip: Know your resume
Seriously. Make a point of reading your resume before submitting it, and again before...
SQL Server on Kubernetes Book Published!
I’m super proud to announce that Ben E. Weissman and I have published SQL...
Forums
Update table from other tables
Hi, Basically i have 2 tables check-in and check-out where users check-in and check-out...
private messages gone
hi, Maybe I'm doing something wrong now, but it seems that the option to...
Ask SSC