Browse by Tags

• Common Table Expressions
• Indexed Views
• Query Processing
• sql server 2005

• 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 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