Forum Replies Created

Viewing 15 posts - 181 through 195 (of 552 total)

  • RE: WMI Alerts

    Richard Warr (8/8/2014)


    Koen Verbeeck (8/8/2014)


    Got it right by selecting one of the two correct options. I wonder if if the other option also leads to success.

    It doesn't 🙁

    +1

    (and, thank you,...

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

  • RE: Service Principal Names

    Thank for the post, new one to me.

    I really had no idea what is this all about, I just referred the help and got the below and then selected the...

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

  • RE: What was that field name?

    Thank you for the post, Dave, very easy one. (at least of me, but the ratio is now almost 50-50).

    Seeing the field list in a tool-tip is easy without...

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

  • RE: In-line variable assignment 1

    Carlo Romagnano (8/5/2014)


    A little variation:

    -- this runs

    DECLARE @i int = 1, @j-2 int = 2;

    SET @i += 2;

    SELECT @j-2 * @i

    GO

    -- this raises error

    DECLARE @i int = 1, @j-2 int...

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

  • RE: In-line variable assignment 1

    Thank you, Hugo, it was very simple and easy, for me. 🙂

    (have one sql script written where the variables are assigned this way, so was sure of my choices. I...

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

  • RE: Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it?

    SQLRNNR (8/4/2014)


    Phil Factor (8/4/2014)


    I'm sorry if it got scored too high, but when I ask this as part of a technical interview, it seems to stump a very large proportion...

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

  • RE: Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it?

    barry.mcconnell (8/4/2014)


    I think the point value was appropriate, not due to the difficulty of the question, but rather the value of knowing the basics well. Knowing some arcane bit of...

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

  • RE: Synonym

    thank you for post, simply nice and easy and yet it still fires the curiosity of knowing the answer selected is the correct one. 🙂

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

  • RE: T- SQL Constraints

    William Vach (7/31/2014)


    Good question on sysobjects table. You could also have added a distinct to the select statement, so I would only get any table having multiple constraints only...

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

  • RE: Restore Database Failed: 'Exclusive access could not be obtained because the database is in use.'

    samanta0rodriges (7/30/2014)


    What is the default database for the job step running the restore?

    basically and mainly, the usage of the default DB points to "MASTER", as I did the same to.

    Are...

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

  • RE: Restore Database Failed: 'Exclusive access could not be obtained because the database is in use.'

    Dennis Post (9/27/2012)


    ...

    If you have multiple tabs open, make sure they are not pointing to the DB in question...

    This helped and fixed the problem, thank you

    (Using... MSSQL 2012 DEV EDT)

    Msg...

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

  • RE: In-Memory feature

    Thank you for the post, interesting one.

    I guessed and got it wrong, didn't had even a nearest clue what I was looking for, but this opened a new door for...

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

  • RE: BCP results

    Hugo Kornelis (7/28/2014)


    ... And then I also had to create a folder Exports in the C: root before I could finally run the script.

    Thanks, Hugo, this explains everything

    Hugo Kornelis (7/28/2014)


    However,...

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

  • RE: BCP results

    Thank you for post, really nice one.

    I got it right for this reason, but I am not sure or I have not yet checked in the SQL if this is...

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

  • RE: Sub Query

    Roland C (7/24/2014)


    Certainly I missed something, but what about http://technet.microsoft.com/en-us/library/ms187638%28v=sql.105%29.aspx ?

    In queries that include a correlated subquery (also known as a repeating subquery), the subquery depends on the outer...

    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 - 181 through 195 (of 552 total)