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

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    February 18, 2014 at 1:20 am

    #1689763

  • RE: Snapshot Agent

    Hard one this was.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    February 17, 2014 at 6:02 am

    #1689466

  • 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...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    February 17, 2014 at 6:00 am

    #1689465

  • RE: Valentines Day

    Interesting finding, thanx Steve.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    February 15, 2014 at 1:46 am

    #1689275

  • RE: LIKE and NULLs

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

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    February 12, 2014 at 11:24 pm

    #1688605

  • RE: Logic Precedence

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

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    February 12, 2014 at 12:29 am

    #1688219

  • RE: Character Field Declaration

    Thanx 4 the easy point.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    February 11, 2014 at 8:23 am

    #1687929

  • 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...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    February 11, 2014 at 8:22 am

    #1687928

  • 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...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    February 10, 2014 at 8:15 am

    #1687557

  • RE: Temporary table in a batch

    bitbucket-25253 (2/8/2014)

    Interesting question

    + 1, yes.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    February 10, 2014 at 2:30 am

    #1687460

  • 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...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    February 10, 2014 at 2:29 am

    #1687459

  • RE: Analysis Services Tabular

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

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    February 9, 2014 at 2:10 am

    #1687362

  • 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

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    February 9, 2014 at 1:14 am

    #1687361

  • RE: Analysis Services Tabular

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

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    February 6, 2014 at 7:33 am

    #1686596

  • RE: Analysis Services Multidimensional

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

    I really hate SSAS.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    February 6, 2014 at 4:13 am

    #1686520

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