Forum Replies Created

Viewing 15 posts - 2,221 through 2,235 (of 3,348 total)

  • RE: MERGE

    cengland0 (2/15/2012)

    The BOL reference also says:

    The MERGE statement requires a semicolon (;) as a statement terminator. Error 10713 is raised when a MERGE statement is run without the terminator.

    I didn't...

    February 15, 2012 at 5:11 am

    #1447272

  • RE: EXECUTE

    cengland0 (2/14/2012)

    Technically, both statements could execute if you just happened to have a stored procedure with the name [use master dbcc showfilestats]. I know, this is crazy but did...

    February 14, 2012 at 2:55 am

    #1446698

  • RE: EXECUTE

    Koen Verbeeck (2/14/2012)

    kll 51891 (2/14/2012)

    I would have expected it to fail due to no newline or semicolon.

    But it were not so

    Anywhere I can find specific rules about when to...

    February 14, 2012 at 2:22 am

    #1446680

  • RE: Indexed Views

    Revenant (2/13/2012)

    jascunce (2/13/2012)

    This is interesting. The actual execution plan from the Std instance with sp1 reports that the clustered index from the base table, not the view, was used in...

    February 13, 2012 at 3:10 pm

    #1446549

  • RE: Indexed Views

    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 regarding the...

    February 13, 2012 at 12:25 pm

    #1446448

  • RE: Read Uncommitted, locks, and transactions

    cengland0 (2/13/2012)

    This was a good question. I like how it was written in the terms of a real problem to solve.

    What other ways can you change the entire contents...

    February 13, 2012 at 3:26 am

    #1446142

  • RE: Indexed Views

    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: Index hints supplied...

    February 13, 2012 at 3:16 am

    #1446138

  • RE: Read Uncommitted, locks, and transactions

    Great question. I especially liked how you explicitly included the rationale for (and dangers of) using NOLOCK.

    Thanks!

    February 13, 2012 at 1:46 am

    #1446115

  • RE: Indexed Views

    Rowles (2/10/2012)

    The answer included this statement:

    "The query optimizer in lower editions will only consider the indexed view if you use the NOEXPAND table hint."

    In SQL Server 2008 Standard with no...

    February 11, 2012 at 3:55 am

    #1445888

  • RE: Indexed Views

    sjimmo (2/10/2012)

    Hugo

    And I have never seen a real-world case where there was more than a single index on a view

    Does that mean that there couldn't be more than one? Does...

    February 10, 2012 at 11:31 am

    #1445707

  • RE: Indexed Views

    SathishK (2/10/2012)

    Using NOEXPAND hint, says the optimizer to consider the index and it won't force its usage. To force a particular index usage, the optional INDEX() clause need to be...

    February 10, 2012 at 8:37 am

    #1445616

  • RE: Indexed Views

    I hate questions where I have to second-guess the author. Did the author mean that the optimizer would choose to use the indexed view automatically? Or did he mean that...

    February 10, 2012 at 2:32 am

    #1445410

  • RE: Using SP_

    john.arnott (2/8/2012)

    I prefer "usp_" myself.

    I prefer not using a prefix at all. I never understand why people think anyone would need a prefix such as "usp_" to be reminded that...

    February 8, 2012 at 10:54 am

    #1444673

  • RE: INSERT OUTPUT

    cengland0 (2/8/2012)

    Hugo Kornelis (2/8/2012)

    You are aware that mainstream support for SQL Server 2005 has already ended, are you? I'd consider upgrading, if I were you... :hehe:

    You're right that the ideal...

    February 8, 2012 at 4:23 am

    #1444410

  • RE: INSERT OUTPUT

    monpara.sanjay (2/8/2012)

    Where is the DATE datatype in sql server??????????

    In all versions since SQL Server 2008.

    You are aware that mainstream support for SQL Server 2005 has already ended, are you? I'd...

    February 8, 2012 at 1:25 am

    #1444321

Viewing 15 posts - 2,221 through 2,235 (of 3,348 total)