Forum Replies Created

Viewing 15 posts - 196 through 210 (of 1,034 total)

  • RE: Halloween Protection

    bitbucket-25253 (10/30/2012)


    Hmm caught me on that one with Halloween coming up in the USA tomorrow thought this was one of those joke questions ... OH well so be it

    Same here......



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • RE: Parsing values in the WHERE clause

    johnf_amic (10/29/2012)


    Good question (Translation: I got it right).

    Hah I'll second that one... the pair in the parethesis just seemed innately wrong to me. A single value didn't... 🙂



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • RE: SELECT (Transact-SQL)

    Thanks, I needed an easy Friday question... the coffee machines are out of order today.



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • RE: PARSENAME

    Koen Verbeeck (10/25/2012)


    Great question about a function I didn't even know it existed 😀

    I knew it existed, but never had much use for it. A guy who I help...



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • RE: Five percent rounded down

    Koen Verbeeck (10/24/2012)


    Interesting question, thanks.

    I do wonder how people are supposed to get this right without running the script.

    I got it right when I realized my answer wasn't on the...



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • RE: A Versioning system for SSRS

    2008R2 and later support Sharepoint 2010 quite handily. Turn on the Document Version control for the site and you have each saved change in the history.

    Not with check-in comments...



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • RE: Table Variables

    Wow.... I knew I had to have this one wrong. I answered it out of memory and didn't even use BOL.

    Imagine my surprise when I was one of the...



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • RE: STR

    Michael Poppers (10/18/2012)


    I answered the QotD based on how I received it (STR(123.45, 2, 2)) via email. The Webpage currently lists a different statement (iirc, STR(987.65, 2, 3)) --...



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • RE: Noise

    I knew what they were, but I couldn't remember the nomenclature. So I popped open BOL and searched for noise words. Which took me to the stopwords area...



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • RE: VIEW - 9

    My only thought was.... where is the index for the statistics?

    I kept trying to figure out a way that would have allowed for the statistics, but couldn't come up with...



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • RE: While loop 2

    Saw the division by zero error.... and knew it was 4.

    Thanks for a question that I can unequivically feel that I know the answer to 🙂



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • RE: Dynamic Grouping in SSRS Reports

    jcrawf02 (10/11/2012)


    Interesting idea, have you seen a lot of use for this? Seems to me if the users wished to dig into the data and summarize on their own, they...



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • RE: T-SQL

    Good question, at least I didn't have to think too hard about this one and got it right.

    Then I started reading the discussion on Seeds and Hugo and Tom's discussion...



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • RE: SELECT

    sam.dahl (10/4/2012)


    I recognised the attempt to insert null and hence picked 2,0 because that's what the two select statements return: 2 and 0. It's the insert statement that fails.

    The question...



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • RE: FTS

    I wouldn't call this one easy or hard, but I'm glad I was able to answer it correctly without having to use google or think too hard... 🙂



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

Viewing 15 posts - 196 through 210 (of 1,034 total)