Presenting to VBUG Bracknell UK 7th Sept
http://vbug.co.uk/events/default.aspx
I'm making a presentation on some aspects of my work for Regus http://www.regus.co.uk/ for the UK or http://www.regus.com/ for the USA. Regus are the world leading provider in office space sliced and diced any way you might like.
At some point a DBA recognises there are only so many indexes you can add and so much hardware you can throw at a database and must get down to the finer points of T SQL. I'm hoping to present some interesting aspects of how sometimes a solution is anything but obvious. As always the presentation will be real world based; some of the subjects I hope to cover include dealing with archiving through partitioning and how you go about applying partitioning to a production database. I hope to give some interesting insights into partitioning you won't find in BOL, and this isn't for a DataWarehouse either.
I have an example of a production issue resolved with calculated columns, but this goes just beyond a simple table change. I have some interesting solutions with queries that the optimiser can't seem to resolve. I have a nice paper on why you shouldn't add columns to a table in an existing database. I also plan to show how to delete 10GB of data from a running database in full recovery ( on my single cpu laptop ) in a matter of a couple of seconds. ( It runs in a few millseconds on my server but will take a little longer on my laptop no doubt )
You could also win an exclusive GrumpyOldDBA Mug.
I've been looking at the use of the CLR vs T-SQL for functions that don't use dml - as yet I've only a couple of examples but the results were interesting