I recently found myself without a speaker for the July SQL Server Club User Group meeting, so when James Rowland-Jones offered to step in, I have to say, I was chuffed to bits.
James is one of the SQLBits conference organisers as well as being a regular speaker. I saw James presenting at SQLBits in Newport back in 2009 and was impressed with his knowledge of SQL Server internals.
SQL Server has a complex, fascinating database engine and I can't help but be wowed when reading about its functions and capabilities. One of my favourite topics is page allocation, fragmentation and how data is stored.
What I previously hadn't given much consideration to is how loading data into a data warehouse is affected by fragmentation. When James emailed me to say this was the subject he would be presenting, I was thrilled.
His presentation will take us back to the basics of fragmentation and we will re-visit all those areas of heaps, clustered indexes and page allocation and how fragmentation arises and has an impact on performance. James will tell us about the trace flags we can use to avoid fragmentation and also what design patterns can be applied to minimise its effects.
I'm really looking forward to this event and it will be a pleasure to welcome James to Bristol. If you would like to attend this meeting, here are the details:
Comments