Forum Replies Created

Viewing 15 posts - 4,456 through 4,470 (of 6,042 total)

  • RE: indexing a table having million of records

    Creating a non-clustered index containing all columns makes no sense. If you create a clustered index on a table, then technically you already have an index that covers all columns....

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Resume font ?

    In the IT arena, I believe that resume font accounts for less than it would for those seeking a position in something like marketing, public relations, or at the executive...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Update is Slow in SQL server 2014

    The first thing to do is compare how the execution plan and number of page read/writes differ between the two databases. You can then focus on why. This can be...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Elevation of Privileges

    Steve Jones - SSC Editor (7/31/2014)


    Eric M Russell (7/31/2014)


    If the windows group like 'MyCorp\ProductionDBA' or 'Builtin\Administrators' are members of SYSADMIN, and user account 'MyCorp\JohnSmith' is added to one of these...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Elevation of Privileges

    If the windows group like 'MyCorp\ProductionDBA' or 'Builtin\Administrators' are members of SYSADMIN, and user account 'MyCorp\JohnSmith' is added to one of these groups, then he has sysadmin privillage. There is...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Elevation of Privileges

    Steve Jones - SSC Editor (7/30/2014)


    Eric M Russell (7/30/2014)


    SQL Server Audit has an 'Addlogin' event and a 'Add Login to Server Role' event. For example, when a login is created...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Elevation of Privileges

    SQL Server Audit has an 'Addlogin' event and a 'Add Login to Server Role' event. For example, when a login is created or granted membership in SYSADMIN group.

    http://msdn.microsoft.com/en-us/library/ms188646.aspx

    But this...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Frustration with Bad Design

    .

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Frustration with Bad Design

    Whether it's a frustrated IT professional wanting to raise awareness to an issue, or a law enforcement officer serving a search warrant, folks need to put their emotions aside and...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Frustration with Bad Design

    GoofyGuy (7/30/2014)


    Eric M Russell wrote:

    If this guy had played his cards right, he could have been seen as a hero and gotten a promotion (perhaps replacing the whomever is currently...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Frustration with Bad Design

    GoofyGuy (7/30/2014)


    Eric M Russell wrote:

    If this guy had played his cards right, he could have been seen as a hero and gotten a promotion (perhaps replacing the whomever is currently...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Elevation of Privileges

    Security, things like accounts and their functional role, should be part of the system design documentation and also part of the QA test plan.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Frustration with Bad Design

    On March 14, Helkowski made his point rather dramatically by posting the university president’s Social Security number and phone number to reddit. He then sent an anonymous e-mail to the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Access Disdain

    benjamin.reyes (7/22/2014)


    Eric M Russell (7/22/2014)


    Andy Warren (7/22/2014)


    That said, today in 2014 (and ever since the mid-1990's), there are much better options than MS Access if you're looking for a platform...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Access Disdain

    Andy Warren (7/22/2014)


    A good spirited debate! Access pro's, can I challenge you to write something for SSC that shows the power of Access? Top 10 Access mistakes? Deployment model and...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 15 posts - 4,456 through 4,470 (of 6,042 total)