Forum Replies Created

Viewing 15 posts - 2,356 through 2,370 (of 19,560 total)

  • RE: Diff between 2012 and 2008 R2?

    In addition to that article, you will have a hard time finding some of the other cool additions/changes.

    SQL Server 2012 had a huge overhaul with extended events. Lots 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

    August 7, 2014 at 8:26 am

    #1735998

  • RE: Creating Index take a long time

    Shurgenz (8/4/2014)

    when creating the new index on a large table that already has some indexes, the new index could take a long time when tehre is alredy index with...

    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 7, 2014 at 8:20 am

    #1735994

  • RE: Today's Random Word!

    Ed Wagner (8/7/2014)

    TomThomson (8/7/2014)

    SQLRNNR (8/6/2014)

    Sean Lange (8/6/2014)

    Ed Wagner (8/6/2014)

    TomThomson (8/6/2014)

    Ed Wagner (8/6/2014)

    SQLRNNR (8/6/2014)

    Ed Wagner (8/6/2014)

    djj (8/6/2014)

    Ed Wagner (8/6/2014)

    SQLRNNR (8/5/2014)

    EL Jerry (8/5/2014)

    Revenant (8/5/2014)

    Yellow

    Pages

    Eight

    Kilobytes

    Kilo Class

    Nautilus

    Nucular

    Attack

    Defense

    Self-Defense

    nunchucks

    self-offense

    masochism

    Strange

    love

    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 7, 2014 at 8:09 am

    #1735985

  • RE: Table size is Huge!!!

    Jeff Moden (8/7/2014)

    mssqlsrv (8/6/2014)

    You can create Server and database audit to check what and who is inserting records in a table.

    Also if possible use partitions for performance.

    Oh, be careful now......

    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 7, 2014 at 8:02 am

    #1735977

  • RE: Troubleshoot the SQL server error log

    If you can't find any SQL Services in the Services control panel then you are looking at the wrong machine.

    Verify the server name and try again.

    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 6, 2014 at 6:32 pm

    #1735820

  • RE: SQL DBA high ended question (5+ years’ experience)

    GilaMonster (8/6/2014)

    Luis Cazares (8/6/2014)

    Eirikur Eiriksson (8/6/2014)

    benjamin.reyes (8/6/2014)

    Eirikur Eiriksson (8/5/2014)

    Grant Fritchey (8/5/2014)

    Eirikur Eiriksson (8/5/2014)

    Guess one has to differentiate between five years of work and five years worth of experience. Questions like...

    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 6, 2014 at 6:29 pm

    #1735819

  • RE: Table size is Huge!!!

    ScottPletcher (8/6/2014)

    LutzM (8/6/2014)

    Here are a few options to make that single table "smaller":

    If the table contains a rather large number of columns (e.g. 50 or more) you might consider "vertical...

    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 6, 2014 at 5:04 pm

    #1735812

  • RE: Today's Random Word!

    Sean Lange (8/6/2014)

    Ed Wagner (8/6/2014)

    TomThomson (8/6/2014)

    Ed Wagner (8/6/2014)

    SQLRNNR (8/6/2014)

    Ed Wagner (8/6/2014)

    djj (8/6/2014)

    Ed Wagner (8/6/2014)

    SQLRNNR (8/5/2014)

    EL Jerry (8/5/2014)

    Revenant (8/5/2014)

    Yellow

    Pages

    Eight

    Kilobytes

    Kilo Class

    Nautilus

    Nucular

    Attack

    Defense

    Self-Defense

    nunchucks

    self-offense

    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 6, 2014 at 5:02 pm

    #1735811

  • RE: Byte Me: Hardware Error

    Miles Neale (8/6/2014)

    Over the years trying to solve some frustrating problems that seem to have no answer, I have found the problem to be about that stupid. Far too...

    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 6, 2014 at 1:14 pm

    #1735755

  • RE: Today's Random Word!

    Ed Wagner (8/6/2014)

    djj (8/6/2014)

    Ed Wagner (8/6/2014)

    SQLRNNR (8/5/2014)

    EL Jerry (8/5/2014)

    Revenant (8/5/2014)

    Yellow

    Pages

    Eight

    Kilobytes

    Kilo Class

    Nautilus

    Nucular

    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 6, 2014 at 11:25 am

    #1735717

  • RE: Are the posted questions getting worse?

    rodjkidd (8/6/2014)

    Stefan Krzywicki (8/6/2014)

    rodjkidd (8/6/2014)

    Stefan,

    Glad to hear everyone is OK. Although after Friday you might be walking funny still!

    Yeah I'd defiantly leave that bit out of the story in future....

    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 6, 2014 at 11:23 am

    #1735715

  • RE: Are the posted questions getting worse?

    rodjkidd (8/6/2014)

    Stefan,

    Glad to hear everyone is OK. Although after Friday you might be walking funny still!

    Yeah I'd defiantly leave that bit out of the story in future. :w00t:

    Rodders...

    Nobody can force...

    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 6, 2014 at 11:22 am

    #1735714

  • RE: Are the posted questions getting worse?

    Sean Lange (8/6/2014)

    Stefan Krzywicki (8/6/2014)

    Ed Wagner (8/6/2014)

    Stefan Krzywicki (8/6/2014)

    Sean Lange (8/6/2014)

    Stefan Krzywicki (8/6/2014)

    Well, it finally happened. I've been threatened with it my entire career. You hear about it in meetings...

    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 6, 2014 at 11:21 am

    #1735712

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (8/6/2014)

    Well, it finally happened. I've been threatened with it my entire career. You hear about it in meetings all the time, but you figure it is just hyperbole....

    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 6, 2014 at 11:19 am

    #1735710

  • RE: Table size is Huge!!!

    smtzac (8/5/2014)

    thanks for your time. One more question, how can I track what causing GB growth? Is there any script I can run to track table size growth/index size?

    Sure, use...

    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 5, 2014 at 7:59 pm

    #1735455

Viewing 15 posts - 2,356 through 2,370 (of 19,560 total)