THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Indexed Views   (RSS)
  • NOEXPAND query hint returns wrong results – CU fix now available

    Three days ago at my current gig we stumbled across a problem where use of the NOEXPAND query hint was causing different results compared to the same query without NOEXPAND. For those that do not know (which, until three days ago, included me) NOEXPAND governs the use of indexed views: The indexed view is not expanded only if the view is ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 4, 2013
  • Connect Digest : 2011-06-27

    Sorry I have fallen off the Connect Digest wagon for the past few weeks; been a little swamped since returning from SQLCruise Alaska. Not sure I'll be able to assemble a digest every week, but I'll certainly try to keep a steady pace. This week I wanted to highlight a few suggestions around indexed views. With the coming of SQL Server code-named ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on June 27, 2011
  • Connect Digest : 2011-05-23

    Next week I'll be up in Alaska for SQL Cruise, so I'll be skipping at least one digest. This week I gathered a few engine-related issues, two involving what the engine does while an index is being created. The most important one, though, at least IMHO, is the first one listed, involving a hashing algorithm fix that is in SQL Server 2008 R2 - but ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 23, 2011
  • Connect Digest : 2011-05-16

    This week we're going to take a look at issues with filtered indexes. This feature was a very welcome addition in SQL Server 2008 and has enjoyed widespread usage if conversations on twitter and forums are any indication. But their implementation is not perfect - bugs in SSMS and numerous restrictions on their use have certainly reduced their ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 16, 2011
  • Mixing OLTP and reporting using indexed views

    I'm not a big fan of denormalizing, nor of repeating redundant redundant information in a database when those facts can already be derived from other information.  A classic example of the latter is when I see questions on newsgroups, forums or StackOverflow that ask how they can update a table's rank column to reflect the current rank based ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 29, 2009
  • Connect Digest : 2009-10-30

    Light helping this week.  I am busy closing out a few projects (or at least chapters within projects) in preparation for PASS next week. ======================================== #506453 : Lock escalation no longer kicks in for INSERTs in SQL Server 2008 Adam found a nasty lock escalation bug in SQL Server 2008.  This one ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 30, 2009
  • Connect digest : 2009-07-04

    I know most readers are out polishing their grills, buying hamburger buns and preparing potato and macaroni salads.  I am recovering from a pre-4th party, so here I am, groggy and online, finally not the host of Independence Day madness.  :-) This week I only have a few entries for the Connect ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 4, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement