This procedure using OLE object calls to obtain server disk space values and writes them to a table. It then creates an HTML report based on the contents of the table and then , via a SQL Agent job, sends out colour coded emails relating to how much drive space is left... this is very handy!!!!
2016-03-16 (first published: 2016-02-25)
1,041 reads
How to monitor drive space in T-SQL and calculate when your drives will run out of space.
2016-01-19
8,309 reads
2016-12-06 (first published: 2015-07-27)
2,480 reads
Reports on the data and log file sizes and space used within files for each database on a servers. It also includes the free space on the drive where the file is located.
2016-03-10 (first published: 2015-07-23)
4,286 reads
Learn an easy, rough, and ready way to manage log files in this piece.
2016-12-16 (first published: 2015-03-09)
9,767 reads
2004-09-22
MAN! cdeaton you sure are a "glass-half-empty" kind of person. Maybe just having a cynical day? Cheers to you.Article was great. Nice to have everything listed together, with examples and all! sp_who2 is already a favorite.-- Mark K.
2004-08-30
Looks to me like the problem might be with your Inner Join:FROM Table t Inner Join Table1 t1 On T.HIDDateTime = T1.HIDDateTime WHERE (T.HIDDateTime BETWEEN @FromDate_LU AND @ToDate_LU) This might work a lot better for you.
2004-08-05
Sample code for VB:http://support.microsoft.com/default.aspx?scid=kb;EN-US;182290Search google for "multiple recordsets" you should find quite a few references.
2004-08-02
Your copy of EM is probably polling the server; turn off polling on the system through EM.Another thing to note (we got bit on this one): do not "hide" your MSSQL 2K instances. This is documented in the KB.One last thing - we found that when running multi-instance installations of MSSQL, even thought 1434 is blocked […]
2004-07-30
This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...
By Steve Jones
I almost missed this month, so this is also a good #SQLNewBlogger post. I...
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
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