Last Tuesday evening, we held our SQL Server event in Bracknell which went really well. Our presenters included Colin Leversuch-Roberts (aka GrumpyDBA) and Neil Hambly. A special thanks goes to Neil for travelling up from Kent.
Colin has presented sessions for us in the past and it’s always great to hear him speak. Some things that I learnt were:
• A reminder about the size that null columns take up in indexes and the effect of creating foreign key relationships against null columns
• Tips on how adding columns onto tables can damage the performance of queries that you have optimised
• Using computed columns and placing indexes on computed columns. Database schemas containing IsActive, IsDeleted type columns could benefit from this
• Creating indexes on bit columns and how it can help performance
• Comments about how CTE’s have been optimised and perform much better in the SQL2008 releases
During the second part of the evening, Neil Hambly did a talk on Data tier applications (DAC). A very helpful part of this was a comparison of Database Projects against DAC. This was the first time that I had seen DAC in action and I can see how it could be useful in some of the work that I do.
Essentially, DAC enables developers to develop a database solution (create tables, stored procedures, functions) and to create a single package which is handed over to the DBA. You can update your Data Tier Applications and the updates can be viewed and managed through Management Studio.
To learn more about DAC, I’d recommend seeing Neil’s presentation at the SQL Bits conference in York on Saturday 30th September 2010. More details below: