Post reply

Not Again!

  • February 18, 2015 at 12:05 am

    #398034

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

  • February 18, 2015 at 12:39 am

    This was removed by the editor as SPAM

  • February 18, 2015 at 1:07 am

    #1778267

    good question. reminded me some old thoughts 🙂

  • February 18, 2015 at 1:07 am

    #1778268

    twin.devil (2/18/2015)

    good question. reminded me some old thoughts 🙂

  • February 18, 2015 at 1:41 am

    #1778277

    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.

  • February 18, 2015 at 2:04 am

    #1778282

    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.

  • February 18, 2015 at 2:04 am

    #1778283

    Surely this must be a bug?

  • February 18, 2015 at 2:47 am

    #1778288

    ..

  • February 18, 2015 at 3:48 am

    #1778297

    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

  • February 18, 2015 at 5:34 am

    #1778311

    Learned somthing new for me today, thanx!

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • February 18, 2015 at 6:47 am

    #1778326

    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!

  • February 18, 2015 at 6:55 am

    #1778327

    Very interesting question

  • February 18, 2015 at 7:13 am

    #1778337

    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.

    😉

  • February 18, 2015 at 7:49 am

    #1778354

    Thanks for the question.


    Everything is awesome!

  • February 18, 2015 at 7:58 am

    #1778358

    Good one, Memory recall.

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

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