To be honest I only ever let the MDF file grow by itself under extreme circumstances (never had one yet), I tend to allocate enough storage for the next 6...

I'd agree with that, but if you really want to get in depth with what should be indexed as opposed with what is currently being done then you'll also need...

You could always just decrypt the SP to see what it's doing.

I'm sure you'l find something usefull in the link below

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26

Hi there, sorry I was offline all weekend , shocking isn't it

Lets see, first can you check...

that'll teach me to have a look through the old stuff first

Thanks Greg

What sort of tasks are you doing in your maintenance plan? If you're updating statistics what sample rate are you using?

We had an issue once with the maintenance plan using...

I know it's a stupid question but is the scheduled job set to run as SA or an administrator?

I've also used this and find it to be a reliable product, it really comes into it's own for things like change control and Disaster Recovery as DTS packages are...

I've seen maintenance plans to backup the transaction log stop working in the past because of a lack of available disk space where the backup is going to, I'm sure that...

Hi Meredith, I'm fairly certain that's what he means, basically make sure that there's plenty of free space on the drive where the database's are living.

Hi Meredith,

I can't remember what the upper limit is on a SQL database but we're currently around the 1TB size with one of ours and it's still going strong (actually...

I always leave the autogrow turned on (just in case) but manually grow the database every 6 months (with enough free space to last) and then do a defrag, allowing...

hmmmm... good question, i'd go as far as saying the reason that it does this is because it's not very good

Hi Mike,

I'd agree that this is an excellent conference, the only complaint that I had is that it was too similar to last years event from a SQL Server perspective,...

We tend to let developers have full reign on DTS packages on all development and test servers, when they're happy they do what they're supposed to I load it up and...