Forum Replies Created

Viewing 15 posts - 3,841 through 3,855 (of 6,035 total)

  • RE: The Scientific Method: a call to action

    Kyrilluk (5/26/2015)


    It would be nice to have this scientific method to all the blab about security as well. Like "I shouldn't give the sysadmin password to the developers because of...

  • RE: Database security question

    robin.pryor (5/26/2015)


    The company I work for insists on being really liberal with db_owner. For the most part, that's not a problem, but security is an issue. Is there a way...

  • RE: Would a Duress Password be a Good Idea?

    Wayne West (5/25/2015)


    Ross McMicken (5/25/2015)


    GPO (5/23/2015)


    Of course all of this assumes your DBA or sysadmin is beyond reproach. I worked as a bank clerk many years before I'd ever heard...

  • RE: Naming Confusion

    Gary Varga (5/22/2015)


    Eric M Russell (5/22/2015)


    Gary Varga (5/22/2015)


    Eric M Russell (5/22/2015)


    T_Peters (5/21/2015)


    I've run into various naming conventions that have caused problems over the years. One of my favorites was naming...

  • RE: Naming Confusion

    Gary Varga (5/22/2015)


    Eric M Russell (5/22/2015)


    T_Peters (5/21/2015)


    I've run into various naming conventions that have caused problems over the years. One of my favorites was naming printers after the 7 Snow...

  • RE: Is it possible to determine the dataflow within a database?

    The high level data flow depends on the sequence for which the application calls the stored procedures, so perhaps ask the application team if they have a diagram. Also, running...

  • RE: Multiple Apps in one Database

    mrl6254 (5/21/2015)


    I’m involved in an application where a database is to be migrated over to a new server.

    I have been told that numerous applications each today with their own database...

  • RE: Naming Confusion

    T_Peters (5/21/2015)


    I've run into various naming conventions that have caused problems over the years. One of my favorites was naming printers after the 7 Snow White dwarfs. It was a...

  • RE: Columnstore Query Reverting to Row Mode with CROSS JOIN

    If you feel confident that this particular query should always leverage the non-clustered columnstore index, then have you tried an index like so?

    WITH (INDEX (IX_EmployeeReview_CS))

  • RE: Naming Confusion

    Executive managment has requested that available MB disk storage (zero padded to 10 digits) be appended to the end of all server names. You know... as a convenience for the...

  • RE: Naming Confusion

    dmbaker (5/21/2015)


    Eric M Russell (5/21/2015)


    Why is including location in server name important for some?

    Because when I'm querying a London server from Seattle, I like to know that I can step...

  • RE: Naming Confusion

    Why is including location in server name important for some?

  • RE: Naming Confusion

    Server names that include it's physical location are problematic when the server is relocated to a different data center. Like wise a name like MSSQL2012 is problematic when it's upgraded....

  • RE: Controlling Alerts

    Gary Varga (5/21/2015)


    A recent client had a system where known potential faults, e.g. missing data that cause overnight job failures, had a documented resolution. These resolutions where not aimed at...

  • RE: SQL 2012 table read performance

    Tom_Sacramento (5/20/2015)


    Yes, limited columns gives much better performance

    It looks like the results are for a handful of tables in MASTER database. When running the script, change context to database containing...

Viewing 15 posts - 3,841 through 3,855 (of 6,035 total)