1. That it is possible to have a Victorian house built in the 1930’s: I’m in the process of buying a new house, and one I saw listed was Victorian terraced. When I viewed the property I wasn’t too surethat it was Victoarian so I asked the agent when this property was built. “1930’s.” was the response. “Oh, I read on the listing it was Victorian” I replied, hoping for further clarity. “Yea, yea.” was the agents clarification…
  2. That the beginning of a book can be the end, and the end be not in the book, and the last few pages of a book be the middle: I finally finished Infinite Jest, a book I’d been promising to read for about two years. For me, the effort involved outweighed the enjoyment I got from reading the book. To contradict that, I want to read it again, but after reading some of the texts cited in the reviews of the book. I don’t want to post spoilers (trust me, what I’ve written in bold above does not reveal anything), but I’ve come away from the book wanting to read reviews, articles etc on the book, and it’s challenged me, so it;s certainly had an impact on me, in a good way.
  3. That it is possible to have other indexes on tables that have Clustered Columnstore Indexes on it: but you need to consider all the implications. [tweet https://twitter.com/BrentO/status/448440613206511616] [tweet https://twitter.com/rusanu/status/448450469338165248] [tweet https://twitter.com/BrentO/status/448451244609114113] This isn’t a knock on Brent’s advice, it’s a clever solution and I’m sure he’d expect people to go check their work before adding indexed views on CCI tables. When testing this solution I found the indexed views to be more than twice the size of the compressed table, so it’s not as if the solution is without it’s disadvantages which Brent goes over at the end of the post.
  4. That it’s possible to bite off more than you can chew: I failed the 70-462 exam last Friday. What with moving house, reading literary (and literally) heavyweight books, spending time with the baby, and learning about Clustered Columnstore Indexes, revision time was at a minimum. It’s not the first time I have failed an exam, it won’t be the last, and I know where I messed up: lack of revision. So time to book my second shot and get revising. I got my arse kicked by the exam and I didn’t like it, so I’m going to work that much harder to pass this exam.