Great article, thanks.

For me, point 1 hit home the most. I recently wrote an application that queried a table with a varbinary(max) column without specifying the columns that I required...

Thanks for the advice fellas, much appreciated. The hosting company are insisting they do this themselves, but I'll ensure they follow the advice you've given above.

Regards

Hi - thanks for the script Lester, it will save me a lot of time!! This is the version I used to restore from 2000 to 2008 - some slight...

Some very good pointers there guys, thanks a million. I'd imagine some kind of archiving process along with a server side trace would suffice, particularily if the trace was set...

I'd certainly agree that a registry hack is not the way forward. Unfortunately though where I work an auditors word is always taken ahead of mine! Interesting point tho whether...

Great article Ken. Much appreciated.

Can I ask your views on the following - I recently had auditors in and one of their recommendations was to increase the maximum number of...

Thanks David. I figured removing them wouldn't cause any issues, but still I reckon leaving them there wouldn't be a risk either. Me thinks my boss will side with the...

Hi Samaspin

Did you ever get anywhere with this? I'm designing a website that sells products with multiple attributes and was thinking of doing a similar design:

1 main product table that...