Tag: Indexes

Indexed views on any core SQL server edition-The video
By Art on October 10, 2015

A few months back I created a blog post showing that you can indeed create and use indexed views on any core SQL server edition. It has proved to be one of my most read blog posts. Since then Webucator, provider of SQL Server training, got in contact asking if they could convert the post into a video. I’ve seen […]

Read More
Using indexed views on ANY core SQL server edition
By Art on August 26, 2014

I was having a discussion the other day and was quite surprised to hear that there still appears to be a slight misconception regarding being able to use indexed views on web or standard editions of SQL server. As it stands the documentation clearly states that you can create and use indexed views on web, standard, BI and enterprise editions […]

Read More
SQLBits XI – My second most eagerly awaited event of 2013…
By Art on January 17, 2013

I bet you are half wondering what is the first? Well that would be the birth of my second child which due in March so you could say that SQLBits XI is my most ‘professional’ eagerly awaited event of 2013. Last Friday I was just about to head off to get some lunch at around 12 and I just happened […]

Read More