Viewing 6 posts - 1 through 6 (of 6 total)
alchemistmatt (4/18/2013)
April 18, 2013 at 7:15 pm
Matt
By how much does your dba database grow daily?
Alex S
Good question; I hadn't checked yet. Turns out I can use the FileStatsHistory table data to answer your question: dba.mdf...
April 18, 2013 at 1:38 pm
I'm now running this in a production environment on 8 servers. I have some suggested fixes for you
Expand [Filename] to NVARCHAR(255) when creating table #BACKUPS. I have some...
April 16, 2013 at 1:48 pm
We have xp_cmdshell enabled on our servers (yeah, I know, that's not best practice). To support this you need to have gen_GetHealthReportToFile check for xp_cmdshell already being enabled. ...
April 13, 2013 at 11:28 am
I haven't run the code yet, but, as far as I can tell, you populate table DatabaseSettings with all DBs with dbid > 4, by default enabling all of the...
April 11, 2013 at 11:19 pm
This looks interesting; thanks for sharing. I downloaded the script from Sourceforge and I see you define and populate field Reindex in the DatabaseSettings settings table. Although this...
April 11, 2013 at 10:54 pm
Viewing 6 posts - 1 through 6 (of 6 total)