Forum Replies Created

Viewing 15 posts - 2,491 through 2,505 (of 19,560 total)

  • RE: Restore of db fails

    So, the backup provided by the vendor will not restore if the destination is backend storage. But it will restore into SQL Server if you use the NAS storage.

    SQL...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 30, 2014 at 9:10 am

    #1733664

  • RE: Are the posted questions getting worse?

    Sean Lange (7/30/2014)

    SQLRNNR (7/30/2014)

    Sean Lange (7/30/2014)

    SQLRNNR (7/30/2014)

    Sean Lange (7/30/2014)

    Lynn Pettis (7/30/2014)

    Second, it comes down to using the right tool for the job and learning what those tools are and how...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 30, 2014 at 8:55 am

    #1733648

  • RE: Elevation of Privileges

    For those that are curious, here is a blog rundown of that attack vector by Andreas.

    http://www.insidesql.org/blogs/andreaswolter/

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 30, 2014 at 8:53 am

    #1733647

  • RE: Are the posted questions getting worse?

    Sean Lange (7/30/2014)

    SQLRNNR (7/30/2014)

    Sean Lange (7/30/2014)

    Lynn Pettis (7/30/2014)

    Second, it comes down to using the right tool for the job and learning what those tools are and how to use them....

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 30, 2014 at 8:47 am

    #1733640

  • RE: Are the posted questions getting worse?

    Sean Lange (7/30/2014)

    Lynn Pettis (7/30/2014)

    Second, it comes down to using the right tool for the job and learning what those tools are and how to use them. If all...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 30, 2014 at 8:32 am

    #1733626

  • RE: Delete statement not delting rows?

    In addition to what Matt has said, you could load up a server side trace to try and capture better visibility into what is happening.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 30, 2014 at 8:27 am

    #1733620

  • RE: Do you usually go to agencies?

    Lynn Pettis (7/30/2014)

    SQL Guy 1 (7/30/2014)

    Ah, if I understand right, you are in US army deployed in Afghanistan?

    And the local agencies they are local to Afghanistan or to...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 30, 2014 at 8:21 am

    #1733614

  • RE: How to Reduce the Table Size...

    Grant Fritchey (7/30/2014)

    Koen's excellent recommendations on compression are really the only way to reduce the size of data stored other than deleting the data.

    Your other options are to try...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 30, 2014 at 8:19 am

    #1733613

  • RE: Tables on seperate filegroups.

    I am in favor of separating the large fact tables into their own filegroups - based on better data and analysis.

    I don't necessarily think that the fact tables should each...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 30, 2014 at 8:15 am

    #1733610

  • RE: Restore of db fails

    Markus (7/30/2014)

    SQLRNNR (7/30/2014)

    Markus (7/30/2014)

    SQLRNNR (7/30/2014)

    Markus (7/30/2014)

    SQLRNNR (7/30/2014)

    The database that they provided, was it enabled for encryption by chance? It is worth checking with the vendor if their database is...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 30, 2014 at 8:01 am

    #1733603

  • RE: Restore of db fails

    Markus (7/30/2014)

    SQLRNNR (7/30/2014)

    Markus (7/30/2014)

    SQLRNNR (7/30/2014)

    The database that they provided, was it enabled for encryption by chance? It is worth checking with the vendor if their database is TDE enabled.

    Also...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 30, 2014 at 7:54 am

    #1733595

  • RE: How to Reduce the Table Size...

    As an aside, I'd avoid shrinking the data file if at all possible. Shrinking has negative consequences that we try to avoid (like fragmentation).

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 30, 2014 at 7:53 am

    #1733594

  • RE: Restore of db fails

    Markus (7/30/2014)

    SQLRNNR (7/30/2014)

    The database that they provided, was it enabled for encryption by chance? It is worth checking with the vendor if their database is TDE enabled.

    Also worth comparing...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 30, 2014 at 7:44 am

    #1733589

  • RE: Restore of db fails

    The database that they provided, was it enabled for encryption by chance? It is worth checking with the vendor if their database is TDE enabled.

    Also worth comparing with them...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 30, 2014 at 7:36 am

    #1733587

  • RE: Multiple joins to the same table

    richardmgreen1 (7/30/2014)

    Just did, and I think it makes sense.

    Why SARG????

    Because we love to shorten things.:hehe:

    Search Argument

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 30, 2014 at 7:32 am

    #1733586

Viewing 15 posts - 2,491 through 2,505 (of 19,560 total)