Performance Gains using Indexed Views and Computed Columns

Posted by NeilHambly on SQL Blogcasts See other posts from SQL Blogcasts or by NeilHambly
Published on Thu, 18 Mar 2010 10:41:00 GMT Indexed on 2010/03/18 11:21 UTC
Read the original article Hit count: 624

Filed under:

Computed Columns

|

Indexed Views

Hello

This is a quick follow-up blog to the Presention I gave last night @ the London UG Meeting ( 17th March 2010 )

It was a great evening and we had a big full house (over 120 Registered for this event), due to time constraints we had I was unable to spend enough time on this topic to really give it justice or any the myriad of questions that arose form the session, I will be gathering all my material and putting a comprehensive BLOG entry on this topic in the next couple of days..

In the meantime here is the slides from last night if you wanted to again review it or if you where not @ the meeting

If you wish to contact me then please feel free to send me emails @ [email protected]

Finally - a quick thanks to Tony Rogerson for allowing me to be a Presenter last night (so we know who we can blame !) and all the other presenters for thier support

Watch this space Folks more to follow soon..

© SQL Blogcasts or respective owner

Related posts about Computed Columns

MySQL use certain columns, based on other columns

as seen on Stack Overflow - Search for 'Stack Overflow'
I have this query: SELECT COUNT(articles.id) AS count FROM articles, xml_documents, streams WHERE articles.xml_document_id = xml_documents.id AND xml_documents.stream_id = streams.id AND articles.published_at BETWEEN '2010-01-01' AND '2010-04-01' AND streams.brand_id = 7 Which just uses the… >>> More
save state of a dataGrid: visible columns, columns width and order

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to save remotely (on a database) the state (visible columns, columns width and order) of a Flex3 DataGrid. For width and visibility I can simply save them by accessing each column attribute.. ugly but possible.. But for the order? Do I have to create the dataGrid dynamically?? Any idea is… >>> More
Minimum permission required to access Site Columns page and edit site columns

as seen on Stack Overflow - Search for 'Stack Overflow'
We've started to adopt SharePoint 2010, and are starting to manually migrate content from SharePoint 2007 sites to new sites we're rebuilding from scratch in SP2010. One of the things we previously had supported was to delegate responsibility for managing some of our site columns to a member of the… >>> More
AWK :Extract columns from file: Rows have variable columns

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a text file in the following format. Each row has variable number of columns. File: gi|269201691|ref|YP_003280960.1| chromosomal replication initiation protein gi|57651109|ref|YP_184912.1| chromosomal replication initiation protein… >>> More
Issue Calculating from Rows and Columns(Summing two columns with the third of a different row)

as seen on Stack Overflow - Search for 'Stack Overflow'
With reference to my previous question Adding columns resulting from GROUP BY clause SELECT AcctId,Date, Sum(CASE WHEN DC = 'C' THEN TrnAmt ELSE 0 END) AS C, Sum(CASE WHEN DC = 'D' THEN TrnAmt ELSE 0 END) AS D FROM Table1 where AcctId = '51' GROUP… >>> More

Related posts about Indexed Views

A Custom View Engine with Dynamic View Location

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Introduction: One of the nice feature of ASP.NET MVC framework is its pluggability. This means you can completely replace the default view engine(s) with a custom one. One of the reason for using a custom view… >>> More
DRUPAL, Views: I cannot change theme from Views settings

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, I cannot change the css theme of my Drupal View. This is a screenshots of the settings: http://dl.dropbox.com/u/72686/viewTheme.png I've tried all buttons, I cannot save the new theme (BlueMarine) in the preferences. It is stuck on Zen (which is my front-end theme). thanks >>> More
Align views in the middle of anotehr views baseline in android

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi.how do u allign views relative to the "middle" part of another view? i think its best explained with a pic of the UI i am trying to create in android http://img228.imageshack.us/img228/3239/howtom.png Thanks in advance >>> More
Passing sql results to views hard-codes views to database column names

as seen on Stack Overflow - Search for 'Stack Overflow'
I just realized that i may not be following best practices in regards to the MVC pattern. My issue is that my views "know" information about my database Here's my situation in psuedo code... My controller invokes a method from my model and passes it directly to the view view.records = tableGateway… >>> More
Drupal, Views: display taxonomies as Views titles.

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, I'm using Views for some nodes, and I want to display a different View title according to which taxonomy tags are selected in my filter. I already have taxonomy field for each node in my view. But this is not what I need. I basically need to display all the currently filtered tags on the top… >>> More