2017-06-16
2,516 reads
Jason Givens
2017-05-01 (first published: 2017-04-19)
1,155 reads
SQL Server Cluster Automatic Memory Management
Don't waste memory in a cluster! Learn how to allocate memory between instances.
2017-04-06
2,954 reads
2017-01-30 (first published: 2017-01-26)
18,809 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,371 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
173 reads
Blogs
Monday Monitor Tips: Searching Permission Changes
By Steve Jones
During a demo of Redgate Monitor Enterprise to a customer, they asked about how...
SQL Bits 2025 Wrap
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
Get Certified in Microsoft Azure Data Fundamentals (DP-900) FAST with NO Experience Needed
By Rohit Garg
As data becomes the backbone of modern business, understanding how to manage and analyze...
Forums
Abobus
Abobus Abobus Casino offers a vibrant and entertaining online gaming experience for players of...
SQL Server 2008 to SQL Server 2022
Hi, Is it possible to upgrade from sql server 2008 to sql server 2022,...
The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Question of the Day
Using Heaps
When does Microsoft recommend using a heap as a table structure (no clustered index)?
See possible answers