Forum Replies Created

Viewing 15 posts - 766 through 780 (of 1,187 total)

  • RE: Views

    Good question. I agree, no scope for criticism. Also, I have made such a view, so I know it can be done. 🙂

    - webrunner

  • RE: General pointers on reading wait statistics

    Thank you, Paul.

    I have read through the waits and queues documents at a high level, but I will go back to it and study it more carefully, as well as...

  • RE: How to query Active Directory from a linked server

    Hello again,

    I'm writing to let everyone on this thread know that I think I resolved this problem.

    Summary:

    1. One of the steps in the AD linked server setup instructions that...

  • RE: Using IDENTITY as a key column

    Hugo Kornelis (4/20/2010)


    dimitri.decoene-1027745 (4/20/2010)


    Moreover, a part of the microsoft online help was a bit misleading on the subject:

    This is because the IDENTITY property is guaranteed to be unique only for...

  • RE: What is the value of SCOPE_IDENTITY()

    I was so happy to get a question right for the first time in 5 tries - even if I did realize it was relatively easy once I looked closely...

  • RE: Map IP Address to a Geographical Location

    Jeff Moden (7/25/2009)


    Heh... sorry Peter... Thought you were trying to flatten the trajectory of a pork chop for some reason. 😀 I'm a bit touchy because I'm trying to...

  • RE: Company Rewards

    I think most rewards that a company would give can be translated into monetary value. For example, any trips, gifts, or services given out by a company would have to...

  • RE: Report Server Web Service

    The 2006 threw me off in terms of guessing, but I am not going to lobby for a point because guessing (even if there is a typo) should not be...

  • RE: ANSI_NULLS

    Great question and explanation.

    Thanks,

    webrunner

  • RE: Rowcount and multiple assignment

    Great question. I got it wrong - I correctly followed the logic of the script but had too little understanding of how ROWCOUNT gets set. Good stuff to know (and...

  • RE: String length?

    Paul White NZ (4/11/2010)


    Very clever question - with some well-thought-out wrong answers 🙂

    First one to whinge about the explanation being 'incomplete' gets a banana :w00t: 😛

    Well done.

    Yes, this was a...

  • RE: Column length

    Tom.Thomson (4/12/2010)


    Oh dear :unsure:. This makes me think maybe Paul was right when he said my post was unclear.

    No, you're right. As I said, I didn't read the...

  • RE: Column length

    I'm late to the party, as it were, so I did not read through each of the posts in the argument between Tom and Paul. So this is not to...

  • RE: TSQL

    dbowlin (4/3/2010)


    It is learning about things like this....one little BIT at a time that make me better and better. Thanks.

    Ha ha - good one!

  • RE: How to query Active Directory from a linked server

    Thanks. The account I'm using is a domain account, and it is being used successfully in another context. However, I have asked to meet with our AD administrator to review...

Viewing 15 posts - 766 through 780 (of 1,187 total)