December 2006 - Posts

• SQL Server 2005 Derived Tables, Common Table Expressions and Indexed Views Query Processing Part III

  So in Part II of this article I had created a View so that I could then create an index on this view to see if that was going to give me the expected results. I did create the view, but not the index. So you probably already know. These columns are non-deterministic Read More... Posted Monday, December 18, 2006 9:14 PM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, Query Processing, Derived Tables, Indexed Views

• SQL Server 2005 Derived Tables, Common Table Expressions and Indexed Views Query Processing Part II

  I have now started the process of evaluating the other possible ways of executing the query. These include using a derived table, Common Table Expression and an Indexed View. My intent is to not use any functions that could twist my results. Below is Read More... Posted Friday, December 15, 2006 11:19 AM by Patrick Gallucci | 1 Comments

• SQL Server 2005 Derived Tables, Common Table Expressions and Indexed Views Query Processing Part I

  I am calling this Part I because I know I still have some more details to discover about something I learned today. Not sure I fully understand it right now, but by the time I get to Part N, I am confident I will know way to much about the subject. I Read More... Posted Monday, December 11, 2006 9:36 PM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, Common Table Expressions, Query Processing, Derived Tables, Indexed Views Attachment(s): SQL Server 2005 Derived Tables, Common Table Expressions and Indexed Views Query Processing Part I.sql