Not Again!

  • sknox

    SSChampion

    Points: 12292

    Comments posted to this topic are about the item Not Again!

  • This was removed by the editor as SPAM

  • twin.devil

    SSC-Insane

    Points: 22208

    good question. reminded me some old thoughts 🙂

  • PRAMANA.DBA

    SSCertifiable

    Points: 5507

    twin.devil (2/18/2015)


    good question. reminded me some old thoughts 🙂

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Thank you for the post, good one. Memory recall, remembered doing this in SQL 2000 instance for one app_user.

    (actually it was not hard to find out the right choice - I knew it was not the permission denial on definition, never knew what that 9485 flag did so had to check on that, and the remaining one must have been correct...)

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

  • andrew.ing

    SSC Eights!

    Points: 847

    Could this be a reason for preferring Count(1) over Count(*) - which is otherwise not an easy decision.

    Edit: No indeed, I misread the question.

  • Toreador

    SSChampion

    Points: 11257

    Surely this must be a bug?

  • andrew.ing

    SSC Eights!

    Points: 847

    ..

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Very interesting question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Hany Helmy

    SSChampion

    Points: 13488

    Learned somthing new for me today, thanx!

  • Brian.Klinect

    Mr or Mrs. 500

    Points: 592

    I learned to today that I can set permissions at the column level. Never even considered trying to do that before.

    I really liked the story that went with the question. Keep up the good storytelling!

  • Bhushan Kulkarni

    SSCrazy

    Points: 2829

    Very interesting question

  • Dave62

    SSCertifiable

    Points: 6664

    I got it right but I don't think Steve got the answer to his question.

    Steve asked the simplest request: how many users on the website?

    I would interpret that question to mean how many users are currently logged on to the website, which is most likely not the total number of ID's in the users table. It's probably a rare occasion, if ever, that all users are logged on at the same time.

    😉

  • Dana Medley

    SSCertifiable

    Points: 6764

    Thanks for the question.



    Everything is awesome!

  • RK Mandava

    SSCarpal Tunnel

    Points: 4153

    Good one, Memory recall.

Viewing 15 posts - 1 through 15 (of 23 total)

You must be logged in to reply to this topic. Login to reply