Forum Replies Created

Viewing 15 posts - 2,821 through 2,835 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Jeff Moden (6/18/2014)

    SQLRNNR (6/17/2014)

    GilaMonster (6/17/2014)

    SQLRNNR (6/17/2014)

    The Dixie Flatline (6/17/2014)

    GilaMonster (6/17/2014)

    Gotta love a review system where an above-average rating requires "Leaves only when work is done and stays to assist others"

    "No...

    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

    June 18, 2014 at 10:54 am

    #1722892

  • RE: Getting Specific Months

    If they insist on a table and tying your hands like that, then you can hide columns in the result set. Just set an expression for each columns visibility...

    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

    June 18, 2014 at 10:52 am

    #1722891

  • RE: Are the posted questions getting worse?

    Sean Lange (6/18/2014)

    On the other side, my current boss says that he does not give anyone exceeds expectations no matter what they do throughout the year. Kind of seems counter...

    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

    June 18, 2014 at 10:46 am

    #1722881

  • RE: Getting Specific Months

    It sounds like you have a table created instead of a matrix.

    Try setting it up with a matrix where the column group will be done on the months.

    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

    June 18, 2014 at 10:43 am

    #1722877

  • RE: Restart DB server good idea?

    GilaMonster (6/18/2014)

    You don't want to reboot it for no reason though. Sure, reboot for OS patches or stuff like that, but rebooting just for the sake of rebooting, no.

    Agreed.

    If you...

    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

    June 18, 2014 at 10:09 am

    #1722865

  • RE: Restart DB server good idea?

    Planned restarts and planned maintenance is a good thing.

    There are OS patches and SQL patches that should be getting rolled out to the server that will typically require a restart.

    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

    June 18, 2014 at 8:47 am

    #1722832

  • RE: No Files For You

    Stewart "Arturius" Campbell (6/18/2014)

    IMHO, it was a coin toss between SQL 2000 and Azure.

    I opted for cloud, as i deduced that using SQL2012 for on-site databases would be unlikely (but,...

    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

    June 18, 2014 at 8:43 am

    #1722830

  • RE: No Files For You

    BWFC (6/18/2014)

    Toreador (6/18/2014)

    You are working for a company that has uses SQL 2012 for their on site databases. A fellow DBA is trying to do a quick check on a...

    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

    June 18, 2014 at 8:33 am

    #1722828

  • RE: Are the posted questions getting worse?

    jasona.work (6/18/2014)

    GilaMonster (6/17/2014)

    Gotta love a review system where an above-average rating requires "Leaves only when work is done and stays to assist others"

    "No pressure to work overtime" they say. :ermm:

    Gotta...

    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

    June 18, 2014 at 8:01 am

    #1722811

  • RE: Are the posted questions getting worse?

    GilaMonster (6/17/2014)

    SQLRNNR (6/17/2014)

    The Dixie Flatline (6/17/2014)

    GilaMonster (6/17/2014)

    Gotta love a review system where an above-average rating requires "Leaves only when work is done and stays to assist others"

    "No pressure to work...

    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

    June 17, 2014 at 4:53 pm

    #1722552

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (6/17/2014)

    GilaMonster (6/17/2014)

    Gotta love a review system where an above-average rating requires "Leaves only when work is done and stays to assist others"

    "No pressure to work overtime" they...

    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

    June 17, 2014 at 4:43 pm

    #1722549

  • RE: Today's Random Word!

    sing4you (6/17/2014)

    eccentricDBA (6/17/2014)

    Ed Wagner (6/17/2014)

    JAZZ Master (6/17/2014)

    Ed Wagner (6/17/2014)

    Stuart Davies (6/17/2014)

    JAZZ Master (6/17/2014)

    Stuart Davies (6/17/2014)

    Sean Lange (6/13/2014)

    Ed Wagner (6/13/2014)

    SQLRNNR (6/13/2014)

    Sean Lange (6/13/2014)

    SQLRNNR (6/13/2014)

    Ed Wagner (6/13/2014)

    SQLRNNR (6/13/2014)

    Sean Lange (6/13/2014)

    SQLRNNR (6/13/2014)

    corner

    penalty

    off-sides

    hands

    PK

    Dive

    flop-artist

    Showboat

    Neymar

    Brazil

    futbol

    Fußball

    Games

    Hunger

    Cooking

    Sherry

    Stroganoff

    couscous

    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

    June 17, 2014 at 4:36 pm

    #1722546

  • RE: Are the posted questions getting worse?

    GilaMonster (6/17/2014)

    Gotta love a review system where an above-average rating requires "Leaves only when work is done and stays to assist others"

    "No pressure to work overtime" they say. :ermm:

    Yeah that...

    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

    June 17, 2014 at 4:35 pm

    #1722545

  • RE: CTE DML

    marcia.j.wilson (6/17/2014)

    SQLRNNR (6/17/2014)

    BWFC (6/17/2014)

    rhythmk (6/17/2014)

    Thanks for question.It reminds me the trick to delete the duplicate records in a table 🙂

    Could you enlighten me on that please? It sounds very...

    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

    June 17, 2014 at 1:16 pm

    #1722480

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (6/17/2014)

    Grant Fritchey (6/17/2014)

    SQLRNNR (6/17/2014)

    Eirikur Eiriksson (6/17/2014)

    Sean Lange (6/17/2014)

    SQLRNNR (6/17/2014)

    Did you notice that the "Active Threads" on your inner window was missing?

    My active threads has been missing most of...

    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

    June 17, 2014 at 1:00 pm

    #1722462

Viewing 15 posts - 2,821 through 2,835 (of 19,560 total)