Forum Replies Created

Viewing 15 posts - 856 through 870 (of 19,560 total)

  • RE: PINTABLE

    Sean Lange (8/26/2015)

    Great question.

    I have always laughed when I saw this because it is all caps it is not exactly clear when reading where the word breaks are. I have...

    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

    August 26, 2015 at 8:53 am

    #1822518

  • RE: PINTABLE

    ygozudeli (8/25/2015)

    I guess the question has a little mistake in the correct answer options.

    When we use EXECUTE function, we have "Command(s) executed successfully" in stead of the default DBCC...

    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

    August 26, 2015 at 8:53 am

    #1822517

  • RE: PINTABLE

    TomThomson (8/25/2015)

    Nice simple question. No wrong answers yet. (Not many right ones, either).

    That changed fairly quickly.

    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

    August 25, 2015 at 10:20 pm

    #1822380

  • RE: Are the posted questions getting worse?

    TomThomson (8/25/2015)

    Sean Lange (8/25/2015)

    Ed Wagner (8/25/2015)

    Alvin Ramard (8/25/2015)

    Ed Wagner (8/25/2015)

    I don't know if it's just me, but SSC has been having some blocks of time where it's very slow recently....

    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

    August 25, 2015 at 10:19 pm

    #1822379

  • RE: How to reset DMV counters

    joe.arias (8/25/2015)

    DBCC FreeProcCache

    While that works to clear the plan cache, it does nothing for the sys.dm_os_latch_stats DMV. Additionally, it's not really recommended to do on a production server, especially since...

    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

    August 25, 2015 at 7:18 pm

    #1822368

  • RE: Are the posted questions getting worse?

    Alvin Ramard (8/25/2015)

    SQLRNNR (8/25/2015)

    Sean Lange (8/25/2015)

    Alvin Ramard (8/25/2015)

    OP is looking for: "... I just looking for good understandable explanation by pptx slides for (Index internals & Isolation levels as well)...

    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

    August 25, 2015 at 10:28 am

    #1822265

  • RE: Are the posted questions getting worse?

    Sean Lange (8/25/2015)

    Alvin Ramard (8/25/2015)

    OP is looking for: "... I just looking for good understandable explanation by pptx slides for (Index internals & Isolation levels as well) and some demo...

    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

    August 25, 2015 at 10:22 am

    #1822262

  • RE: Today's Random Word!

    whereisSQL? (8/25/2015)

    crookj (8/25/2015)

    TomThomson (8/25/2015)

    Ed Wagner (8/25/2015)

    Stuart Davies (8/25/2015)

    Revenant (8/24/2015)

    ZZartin (8/24/2015)

    whereisSQL? (8/24/2015)

    DonlSimpson (8/24/2015)

    Ed Wagner (8/24/2015)

    djj (8/24/2015)

    Ed Wagner (8/24/2015)

    Luis Cazares (8/24/2015)

    whereisSQL? (8/24/2015)

    Ed Wagner (8/24/2015)

    TomThomson (8/24/2015)

    SQLRNNR (8/24/2015)

    oeuf

    revuelto

    Pistol

    Pete

    Mickey

    Mouse

    Moose

    Rocky

    Stalone

    Schwarzenegger

    Geezer

    Me

    Myself

    Eye

    Ore

    Raw

    Refine

    Recline

    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

    August 25, 2015 at 10:08 am

    #1822252

  • RE: Today's Random Word!

    oeuf

    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

    August 24, 2015 at 8:38 am

    #1821985

  • RE: Are the posted questions getting worse?

    Sean Lange (8/19/2015)

    I am working on putting together my first SSIS package. I haven't done this type of thing since it was still DTS packages. This stuff is a LOT...

    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

    August 19, 2015 at 10:02 am

    #1821111

  • RE: columnstore index maxdop

    Hugo Kornelis (8/19/2015)

    I am happy to see questions about columnstore indexes, because I really love this feature. (I love everything that makes SQL Server go faster, actually).

    But I am not...

    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

    August 19, 2015 at 6:46 am

    #1821014

  • RE: Byte Me: Corporate Oversight

    Backup software? That has to be at least as current as many of the apps out there today. 😀

    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

    August 19, 2015 at 6:40 am

    #1821011

  • RE: Database in use

    You run that risk as it is.

    It works about the same either way with about the same amount of risk of another connection stealing the connection.

    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

    August 18, 2015 at 5:09 pm

    #1820918

  • RE: Database in use

    dan-572483 (8/18/2015)

    We have a weekly job that restores a database from a copy downloaded from a vendor. It occasionally fails with the error:

    Msg 3101, Level 16, State 1, Line...

    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

    August 18, 2015 at 4:46 pm

    #1820915

  • RE: Are the posted questions getting worse?

    GilaMonster (8/18/2015)

    I'm not looking forward to September. One flight to Cape Town for SQLSaturday Cape Town, one flight to Durban for SQLSaturday Durban (first event in that city), one flight...

    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

    August 18, 2015 at 3:52 pm

    #1820908

Viewing 15 posts - 856 through 870 (of 19,560 total)