I enjoyed the question thanks.

Yes slightly 'loose' question but it gets you thinking. I answered either, as the structure of data for such things as 'admissions' would probably lend itself to a relational solution,...

Many thanks for the useful script Gianluca. I had to run checks on an old server running SQL Server 2000 (I know they are upgrading soon) so I made a...

Enjoyed the question thanks. It has made me realise that the reseed parameter has to be treated with some care.

Not being sure how many rows would be affected by those statements, I tested with SQL 2008. It worked for me but not sure what I've learnt.

Thanks to you all for your thoughts on my question. It keeps me thinking and learning, which is why I'm here.

All the best for 2013.

Dave.

Hi Bugg,

Lot's of great advice from the peeps that know on here. I'd just reinforce the importance of getting a disaster recovery plan in place and making sure all...

Hi Bugg,

I think 'Trounbleshooting SQL Server, A Guide for Accidental DBAs' by Johnathan Kehayias and Ted Krueger, would be a good read before you start. It's available on the Red...