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
237 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
324 reads
Blogs
Quick Blog: Making the Power BI PowerShell cmdlets easier to use
By Aaron Nelson
One of the top reasons I love PowerShell so much is that from the...
Trouble writing? Join the club. #JustWriteTech
By Jen McCown
I was talking with a couple of excellent SQL people* recently, and we were bemoaning...
Check Query Progress with Live Query Stats
This is something I touched on back in 2017 a little after the Live...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
update table b if b.time falls between any of table a rows start/stop
I'm trying to find a way to rewrite this dusty old cursor set based,...
Check if number exists in a column
Hello, I am pulling some address data from a legacy system and it has...
Ask SSC