SP_DBA_AUTOTRANS_DUMP_LOG
Purpose : This routine will dump the transaction logs based on the percentage on how full the transaction logs are based on parmeter from the logthres table […]
2003-08-01
250 reads
sp_dba_spacealert_dmo.vbs
This vbscript is used to alert and email receipients on Filegroup space usageOuput: '% Space Avail. , Space Avail. Filesize, MaxSize, FileName, DBname, FileGroupThe process takes three arguments - SqlserverName , Threshold for percentage of available space to check ,Mininum MaxFileSize to checkExecute the script either from the command line or schedule the script via […]
2003-08-01
343 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...
Generative AI vs Predictive AI | Real-World Examples & Tools You Should Know
By Rohit Garg
What is Artificial Intelligence? Understanding Predictive vs. Generative AI Artificial Intelligence (AI) is transforming...
SQL Bits 2025 Wrap
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
Forums
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:...
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