2017-06-16
1,862 reads
Jason Givens
2017-05-01 (first published: 2017-04-19)
793 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,509 reads
2017-01-30 (first published: 2017-01-26)
7,894 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,708 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
150 reads
Blogs
[MSSQLTips] Visual Studio 2019 Configuration for the Production DBA
By gbargsley
Happy Tuesday everyone… Today I am honored to have my first article published on...
Daily Coping 22 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Converting a Datetime to UTC
I was in a need of converting some datetime values (of which I know...
Forums
SCOM/SCCM alert when Always On High Availability dashboard is green
Hello experts, Does anyone know why SCOM (or is it SCCM?) would send the...
Restart SQL server from CMD
We have a issue in SQL Server 2017 (RTM-CU21) with SSISDB when a server...
Replication issue
my table is getting replicated from server 1 to server 2. I got a...
Ask SSC