Forum Replies Created

Viewing 15 posts - 586 through 600 (of 716 total)

  • RE: The Model Database

    Koen Verbeeck (2/17/2014)


    The following operations cannot be performed on the model database:

    ...

    Setting the primary filegroup to READ_ONLY.

    Damn you MSDN!

    + 1

  • RE: Snapshot Agent

    Hard one this was.

  • RE: Snapshot Agent

    (2/17/2014)


    Interesting question.

    I could have this wrong , but:

    The statement in the article referenced may apply only to the initial snapshot generation on the publisher (ie to generation of the schema...

  • RE: Valentines Day

    Interesting finding, thanx Steve.

  • RE: LIKE and NULLs

    I remember this one, it came before some months back.

  • RE: Logic Precedence

    I remember a similar question came across QoTd before, but it`s always good to go back to basics, thanx Steve.

  • RE: Character Field Declaration

    Thanx 4 the easy point.

  • RE: Character Field Declaration

    Koen Verbeeck (2/11/2014)


    ashwani24 (2/10/2014)


    Answer is both i.e. success as well as fail, Fail in 2005 or lower version and success in 2008 or above as you have not specified any...

  • RE: Temporary table in a batch

    SQLRNNR (2/9/2014)


    Nice question.

    Not sure why someone would try to create the same temp table twice in the same procedure. If needing to use the same temp table then clear...

  • RE: Temporary table in a batch

    bitbucket-25253 (2/8/2014)


    Interesting question

    + 1, yes.

  • RE: Temporary table in a batch

    L' Eomot Inversé (2/9/2014)


    Nice question.

    But the explanation appears to have swallowed the good old party line: sometimes (and it seems reasonably certain that this is one of those times) "it's...

  • RE: Analysis Services Tabular

    Hard one this, took me some time to got it & and for the same reference in the answer/explanation.

  • RE: Analysis Services Tabular

    Sean Lange (2/7/2014)


    Yet another good question about SSAS. This has been a tough week of questions as I have never used SSAS.

    + 1

  • RE: Analysis Services Tabular

    Had to do some R&D on this this to get it right.

  • RE: Analysis Services Multidimensional

    "A week of Analysis Services", so I guess this week will be hard for me! 😎

    I really hate SSAS.

Viewing 15 posts - 586 through 600 (of 716 total)