Contents tagged with Indexes

  • Indexed views on any core SQL server edition–The video

    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 some of their other work previously which was pretty good so had no hesitations giving them the thumbs up.

    So here is their finished result to complement the original blog post

    & …

  • Using indexed views on ANY core SQL server edition

    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 of SQL server (I’m ignoring developer + evaluation as they are the same as enterprise). You can create a view, materialise that view in the form of a …

  • SQLBits XI - My second most eagerly awaited event of 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 to look up at my emails and saw the email that I had been waiting weeks to see. That was the email saying that SQLBits registrations has now opened. I didn’t hang around at this point. …