Forum Replies Created

Viewing 15 posts - 526 through 540 (of 551 total)

  • RE: Service Service Accounts

    thank you Antony. (yes, R2 is different, 2008 and 2008 R2 needs to be treated as two different things)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • RE: Service Service Accounts

    Sorry for this off-topic question.

    I just installed SP1 on the vmbox running SQL 2008 R2 and can see these objects accessible.

    Just wanted to know, now I see that SP2...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • RE: Service Service Accounts

    Thank you Keon.

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • RE: Service Service Accounts

    anthony.green (2/24/2012)


    Raghavendra Mudugal (2/24/2012)


    SQL Version

    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • RE: Service Service Accounts

    SQL Version

    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition with Advanced Services...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • RE: Object_Id 1

    YAY!!!. I got one point.

    (representation of N - has nothing to do with the collation)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • RE: Model Database

    I selected "NO and NO" 🙁

    NoteToSelf: When it says R2 then refer only the R2-BOL. Referring 2005-BOL will not help.

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • RE: Read Uncommitted, locks, and transactions

    I have seen saying that using NOLOCK is good sign of the poor design.

    In my current work, we use NOLOCK in all SQL statements, (I know its not good)

    from the...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • RE: HASHBYTES

    SathishK (2/10/2012)


    Raghavendra Mudugal (2/10/2012)


    cengland0 (2/10/2012)


    Raghavendra Mudugal (2/10/2012)


    cengland0 (2/10/2012)


    Steve Jones - SSC Editor (2/9/2012)


    SELECT HASHBYTES( 'SHA1', 'R@nd0m' + Pwd + firstname)

    FROM Employees

    In this case, without access to the code, it...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • RE: HASHBYTES

    cengland0 (2/10/2012)


    Raghavendra Mudugal (2/10/2012)


    cengland0 (2/10/2012)


    Steve Jones - SSC Editor (2/9/2012)


    SELECT HASHBYTES( 'SHA1', 'R@nd0m' + Pwd + firstname)

    FROM Employees

    In this case, without access to the code, it becomes hard to...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • RE: HASHBYTES

    cengland0 (2/10/2012)


    Steve Jones - SSC Editor (2/9/2012)


    SELECT HASHBYTES( 'SHA1', 'R@nd0m' + Pwd + firstname)

    FROM Employees

    In this case, without access to the code, it becomes hard to determine what the...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • RE: HASHBYTES

    0xB9A02E529093456D139C69FC5E5D4D825B7EC24B0xCDE457DD8AB6C020E9852FE5B6953E02631A2CB2

    this is the output of your query, just wanted to know what you mean by "exact same results"....?

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • RE: HASHBYTES

    For me this question did not made any sense.

    the sample code is just concatenating another variable to it, you can name it @salt to @sugar... still the sample code will...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • RE: DBAs and the Career-Life Balance

    To be honest, I took the article by very surprise.

    Currently I am working as an Application Support (IT section) in a Shipping company. From the 6.5 to 2012...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • RE: MCITP 70-441 and 70-442 exams - guidence

    G'Day! Bert!

    Thanks a lot.

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Viewing 15 posts - 526 through 540 (of 551 total)