Sean, love the report (but for me it doesn't produce anything for the scheduled SQL jobs recently run?).

You seem to have a list of improvements/additions from the various respondees, so...

Thanks for the offerings.

In terms of heaps, you are right in terms of what sort of data is being applied. In the specific case I rerfered to, the table...

I don't have the transaction logs being backed up via any maint plan and have not seen this option to log things to a file (but will investigate). All the...

Cheers for all the reply's.

I'm unable to post any sort of create database script as the databases were initially setup by a vendor and my only involvement was making sure...

Yes using the full sysadm account. The strange thing is I cannot even get this to work when trying to use t-sql. for some reasons the settings just do not...

The problem database is defined as FULL, the wording was trying (not that clearly perhaps!) to clarify that in one environment (Pre-Prod), this database is able to be defined with...

Nice article and mirroring other comments, it still amazes me how unaware non-DBA's are (especially if they are aspiring to be DBA's) about the bredth of skills a DBA needs...

I did a noddy test on a VARCHAR(MAX) v VARCHAR(nn) for space.

Using only data <100 characters for a sample number of rows, the number of pages for VARCHAR(MAX) and VARCHAR(100)...

I think you are all getting off the original point.

My query was with regard to the appropriate-ness of using VARCHAR(MAX) when the vendor might have had a bit more thought...

If only it were but one vendor!!!

Had one example where the column length was being changed because the size of the field on the app screen was larger than the...

My implication was what should the setting be for all the various resources as a recommendation.

I agree SQLServerAgent if it fails should not 'affect the group'.

But in an attempt...

Fair enough, it was just that I seem to remember some reference to (nolock) dealing with potentially non-commited data and the obvious impacts of that might not be that desirable.

Seems...

Not sure on the validity of (nolock) on a table where you are deleting data?

That aside, you mentioned this has worked in the past, but not so well now.

What you...

I am not talking about the diagram, but Printing.

Once you have the diagram open, try the Print options and in the Print Properties, adjust the output to the desired scale.

I...

Not sure if it a solution to your needs, but if you set your printer properties when producing the printed output, to only have it fit to one page would...