Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • RE: Scripting procedure versions

    Just wanted to throw this out there. If you look in sys.sql_modules, only the definition for the 1st version of stored procedure is reported. This was bugging me a bit...

    March 8, 2019 at 9:16 am

    #2023951

  • RE: A Break from Data

    IceDread (5/25/2012)

    The singular best sci fi movie I have seen as of late is Troll Hunter. http://www.imdb.com/title/tt1740707/

    The start of the movie is a little unusual but it gets...

    May 25, 2012 at 12:31 pm

    #1493338

  • RE: Indexed Views

    Hugo Kornelis (2/13/2012)

    Revenant (2/13/2012)

    All exactly as I expected. This confirms that on editions below Enterprise, the only way to get the optimizer to use an index on the view is...

    February 13, 2012 at 3:28 pm

    #1446559

  • RE: Indexed Views

    Hugo Kornelis (2/13/2012)

    jascunce (2/13/2012)

    Revenant (2/13/2012)

    I ran your code under R2 DataCenter, up to date, and got 'Warning: Index hints supplied for view 'dbo.v1' will be ignored.' 5 times.

    The same results...

    February 13, 2012 at 12:52 pm

    #1446459

  • RE: Indexed Views

    Revenant (2/13/2012)

    Hugo Kornelis (2/13/2012)

    Toreador (2/13/2012)

    On Enterprise edition the results are the same - the view index is used.

    On both this and Developer edition I get a warning for each statement

    "Warning:...

    February 13, 2012 at 11:45 am

    #1446413

Viewing 5 posts - 1 through 5 (of 5 total)