Done. Article Submitted through 'Write for Us'.

I'll take this one.

Hi Steve

I'll take this one.

UK unemployment has increased to 2.5M

http://news.bbc.co.uk/1/hi/8634241.stm

you can delete old backups using maintenance plan.

Nice one Richard.

Thanks, but I know it's done via DBCC SHRINKFILE, but I have very little knowledge of T-SQL, so that's why I was asking for the code. For someone knowledgeable, this...

Sorry thats typo. It should be CustomerID.

Thank you satnam

Thank you Pradeep.

Hi,

This was a brilliant article, highlighting something I've never thouht of before. Thumbs up!

But I have a follow up question: How do you suggest that I write a query...

Correction: you're doing 4 PK clustered index scans (aka table scan) on the LEISTUNGSPREISE table, each time on a different column (KONTO_BUCH, KONTO_STEUER_PROV, KONTO_PROV and KONTO_STEUER_VK). It seems that these...

Thanks for the feedback guys. Much appreciated.

If your Backupfile contains more then 1 backups (perhaps you did back up all Databases in one go) you need to add the filenumber...

do you think it's a bug with SQL Server 2008 R2?

It's backing up the database fine. but not deleting it. so eventhough i gave full control of the folder to the SQL Server service account it wasnt deleting the old...