Forum Replies Created

Viewing 15 posts - 211 through 225 (of 552 total)

  • RE: Random Sample

    christian_nowicki (7/8/2014)

    Using the checksum of a newid as the seed in the rand function does work because the newid is reinterpreted for each row. The only time I'd do it...

    July 11, 2014 at 6:32 am

    #1728715

  • RE: Random Sample

    Hany Helmy (7/9/2014)

    Carlo Romagnano (7/9/2014)

    Thank you for question!

    Theoretically, any query would return different value!

    In practice, Only ORDER BY NEWID() works for us.

    Yes, that`s true, same found here 🙂

    +1

    (to be honest,...

    July 11, 2014 at 5:54 am

    #1728699

  • RE: What is the Output?

    Thank you for the post, very good one.

    July 10, 2014 at 5:34 am

    #1728336

  • RE: Code Names

    Thank you for the post, SJ, easy one.

    Happy Independence Day... Celebrate it by watching Independence Day... (I mean the movie)

    July 4, 2014 at 2:28 am

    #1727022

  • RE: Number of rows returned by different JOINs

    david.gugg (7/3/2014)

    Easy one, thanks. I needed an easy one after getting the last four in a row wrong.

    ...been there... 🙂 totally agree.

    July 3, 2014 at 8:22 am

    #1726843

  • RE: Number of rows returned by different JOINs

    Mighty (7/3/2014)

    Definitely way too easy.

    Still easy, but if table B would have the values 1 and 2, then at least you could have explained something about the different join...

    July 3, 2014 at 3:04 am

    #1726712

  • RE: Number of rows returned by different JOINs

    Koen Verbeeck (7/3/2014)

    Way too easy as you only have to check the first query to get to the right answer.

    Thanks for the effort though.

    +1

    (did the same) Thank you for the...

    July 3, 2014 at 2:24 am

    #1726705

  • RE: The Case Of the Downward Pointing Arrow

    Hany Helmy (7/2/2014)

    To revoke a connect permission from user, this is to be done from the database security level like follows:

    Revoke Connect from User_Name; or to deny the user from...

    July 2, 2014 at 8:27 am

    #1726522

  • RE: The Case Of the Downward Pointing Arrow

    Thank you Andy for the post, very nicely put, but for me it was like "wow I don't know anything about sql".

    I can't figure it out how to revoke and...

    July 2, 2014 at 3:03 am

    #1726414

  • RE: A Deeply Planted Seed

    Thank you, Andy, Very good one.

    I got it wrong - I did a search in a crooked way - my steps were correct and I searched in all databases except...

    July 1, 2014 at 3:43 am

    #1726091

  • RE: How many Records are Returned?

    Thank you Mike for the post, good one.

    June 30, 2014 at 12:59 pm

    #1725959

  • RE: What is 268435456?

    GilaMonster (6/27/2014)

    First line in the answer:

    The limit for us humans is 2TB, but SQL stores the limit as the number of 8KB pages!

    I read that... and also I saw...

    June 27, 2014 at 5:50 am

    #1725389

  • RE: What is 268435456?

    Thank you Andy, nice one and also made it easy for me just two days ago I was looking into the log file's max_size. 🙂

    (bit confused: how this value 268435456...

    June 27, 2014 at 4:31 am

    #1725374

  • RE: Fun with OVER

    barry.mcconnell (6/26/2014)

    Raghavendra Mudugal (6/26/2014)

    Also, can any explain... in query A, when Jean has 1 and Anita and Mary has 3 where did the 2 go?

    In question A the default framing...

    June 26, 2014 at 2:38 pm

    #1725278

  • RE: Fun with OVER

    Also, can any explain... in query A, when Jean has 1 and Anita and Mary has 3 where did the 2 go?

    June 26, 2014 at 11:44 am

    #1725226

Viewing 15 posts - 211 through 225 (of 552 total)