Forum Replies Created

Viewing 3 posts - 16 through 18 (of 18 total)

  • RE: CASE in FROM Clause

    Hallo!

    Try to redefine a task:

    First: I think you do not have to SELECT *

    Second:

     Rewrite code as:

    DECLARE @I INT

    SET @I = 1

    SELECT

        A.*

        ,specificField =

          CASE

            WHEN @i =...

  • RE: Speed of Partitioned Views

    I'm also a little confused about examples.

    I think it will be more interesting to rewrite all examples with indexed view (possible in 2K)

    Hint will be awailable, speed of insert/update/delete is...

  • RE: How to Diagnose and Fix Wait Locks

    This must be in BOL IMUO (In My UNHonest Opinion)

Viewing 3 posts - 16 through 18 (of 18 total)