This script features as we can through the CTE Top10FilesWithLargerDiskConsumption the top ten data files that are showing greater consumption of hard drive related data-reading activities.
2019-01-15 (first published: 2019-01-08)
962 reads
This script validates the sufficient disk space per drive.
When you'll reach a minimum on a diskdrive, the script will mail all recipients.
2011-12-07 (first published: 2011-10-28)
3,858 reads
2013-12-06 (first published: 2011-01-31)
4,651 reads
I have tried to restore a database using a different computer than usual, which did not have the ODBC datasource setup for the database concerned. The database is basically stuffed - I got an error message stating "modify file encountered operating system error 112..."When I installed SQL Server on this computer I set it up […]
2005-05-16
I don't know how are you using the parameter but this sholud helpyou going Declare @str varchar(200) SET @str = DB_NAME()--Assuming is going to be runned from other databases only --otherwise use dbname as a parameter +'.dbo.sp_helprolemember ' + '''' + 'RoleName' + '''' --print @str exec (@str) I don't know why can't the "plus" […]
2003-11-13
2003-11-12
2 reads
Thanks for the tip of using Tab delimted, renamed to XLS. It works great! Using xp_sendmail, do any of you know a way to change the default attached message from .txt to .XLS?
2003-08-28
quote: Our warehouse is currently 26+ Gigs and we load it with delta's daily in under 2 hours (along with the recon reports for balancing). Our datawarehouse is currently only ODS (ADS to be started soon) and 160+Gigs. Our daily loads (including reindexing and reporting) must stay under 12 hours. Can you give an idea […]
2003-08-01
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers