Forum Replies Created

Viewing 15 posts - 286 through 300 (of 19,560 total)

  • RE: Best practice

    jmcnorrill - Tuesday, March 28, 2017 9:41 AM

    OK, here is a sample of the data.

    The records that I will be using will...

    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

    March 28, 2017 at 11:04 am

    #1935323

  • RE: 3 node AOAG 1 out of Sync

    Talib123 - Tuesday, March 28, 2017 3:43 AM

    All dbs are out of SYNC is this the best way to do it. Rather...

    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

    March 28, 2017 at 9:22 am

    #1935296

  • RE: Need function for drop temp table

    I see no benefit to creating a function to drop a table.

    Creating the function just adds a layer of problems.

    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

    March 28, 2017 at 9:16 am

    #1935294

  • RE: Are the posted questions getting worse?

    Grant Fritchey - Tuesday, March 28, 2017 4:19 AM

    Thom A - Tuesday, March 28, 2017 3:09 AM

    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

    March 28, 2017 at 8:15 am

    #1935271

  • RE: Pinned Tables

    Stewart "Arturius" Campbell - Friday, March 24, 2017 12:43 AM

    Thank goodness those days are long gone....
    Thanks for the question, Steve

    Yes - thank...

    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

    March 27, 2017 at 6:10 pm

    #1935188

  • RE: sys.dm_exec_query_stats

    Henrico Bekker - Monday, March 27, 2017 4:12 PM

    Seems MS documentation needs to be updated. 

    Huge understatement

    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

    March 27, 2017 at 6:06 pm

    #1935187

  • RE: Log file growth

    Admingod - Monday, March 27, 2017 1:36 PM

    Thanks for everyone for the replies. The log growth is happened during index maintenance plan....

    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

    March 27, 2017 at 6:04 pm

    #1935186

  • RE: DBCC is running from 5 days

    coolchaitu - Saturday, March 25, 2017 12:48 AM

    SQLRNNR - Friday, March 24, 2017 2:36 PM

    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

    March 25, 2017 at 10:14 am

    #1934935

  • RE: Instance is under memory pressure. How to relieve from pressure

    coolchaitu - Saturday, March 25, 2017 12:32 AM

    Jeff Moden - Friday, March 24, 2017 2:53 PM

    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

    March 25, 2017 at 10:11 am

    #1934934

  • RE: DBCC is running from 5 days

    Sue_H - Friday, March 24, 2017 3:23 PM

    SQLRNNR - Friday, March 24, 2017 2:39 PM

    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

    March 24, 2017 at 10:19 pm

    #1934920

  • RE: Query help

    polkadot - Friday, March 24, 2017 2:41 PM

    I made mistake and corrected:
    CommonAttributes column for shared attributes, and they are 3 and 1.
    4 and...

    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

    March 24, 2017 at 9:49 pm

    #1934919

  • RE: Query help

    polkadot - Friday, March 24, 2017 2:41 PM

    I made mistake and corrected:
    CommonAttributes column for shared attributes, and they are 3 and 1.
    4 and...

    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

    March 24, 2017 at 3:24 pm

    #1934896

  • RE: Instance is under memory pressure. How to relieve from pressure

    I believe the real answer to this question is that the user is running maintenance on the instance (based on the "5-day checkdb" thread recently posted). This will cause the...

    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

    March 24, 2017 at 3:21 pm

    #1934893

  • RE: Tlog backups - indicate no data change

    Steve Jones - SSC Editor - Friday, March 24, 2017 3:12 PM

    Or set the dbs to restricted_user if you app login doesn't...

    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

    March 24, 2017 at 3:19 pm

    #1934891

  • RE: Solution to avoid TEMP tables and CTE's

    Luis Cazares - Friday, March 24, 2017 2:58 PM

    A different solution is to use views or derived tables instead of CTEs.

    That was...

    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

    March 24, 2017 at 3:16 pm

    #1934890

Viewing 15 posts - 286 through 300 (of 19,560 total)