Forum Replies Created

Viewing 15 posts - 961 through 975 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    48 bottles of post on the thread, 48 bottles of post.

    Take one down, pass it around, 48 bottles of post on the thread

    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 10, 2015 at 11:36 am

    #1818653

  • RE: Compatibility Mode causes query not to finish

    Jeff Moden (8/9/2015)

    NP. It IS one of the many reasons why I prefer to not be on the bleeding edge.

    Bleeding edge with major releases, SP, or even CU. Let...

    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 9, 2015 at 8:34 pm

    #1818420

  • RE: SQL Server upgrade from 2008 to 2012 and migration to new server

    Here is an article detailing some of the new stuff.

    https://technet.microsoft.com/en-us/library/Bb500435(v=SQL.110).aspx

    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 9, 2015 at 12:09 am

    #1818387

  • RE: Log shipping .trn file corrupt

    GilaMonster (8/8/2015)

    Shouldn't need to reconfigure log shipping. The settings are in MSDB, the jobs will still be there

    True. They would need to disable the restore job prior to running 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

    August 8, 2015 at 2:44 pm

    #1818372

  • RE: Would the Dedicated Admin Connection have helped here? No SYSADMIN members...

    Jeff Moden (8/8/2015)

    jasona.work (8/8/2015)

    I guess that's what happens when a non-SQL person goes to install SQL.

    You said a mouthful there. I just went through all of that. New...

    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 8, 2015 at 2:30 pm

    #1818370

  • RE: Compatibility Mode causes query not to finish

    This sounds like you may have a couple of queries that fit into the edge cases where they do not work well under the SQL 2014 Cardinality Estimator. For...

    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 8, 2015 at 2:24 pm

    #1818369

  • RE: Today's Random Word!

    Ed Wagner (8/8/2015)

    Eirikur Eiriksson (8/8/2015)

    SQLRNNR (8/7/2015)

    Mood

    🙂 Smiley

    Happy

    Shiny

    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 8, 2015 at 2:16 pm

    #1818368

  • RE: Restricting Sysadmins from adding new sysadmins

    Jeff Moden (8/8/2015)

    Something like CyberArk is absolutely wonderful for making auditors and soccer Moms happy but it always boils down to the root problem and no software in the world...

    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 8, 2015 at 2:16 pm

    #1818367

  • RE: Log shipping .trn file corrupt

    coolchaitu (8/8/2015)

    Madam,

    So,take a full/diff backup after the log chain got broken and ten restore it with norecovery on secondary? Do we need to re-configure log shipping again?

    Yes either a full...

    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 8, 2015 at 2:09 pm

    #1818366

  • RE: Log shipping .trn file corrupt

    coolchaitu (8/8/2015)

    Wayne Sir,

    Thanks lot for reply.Actually,I did not understand. As i am junior level dba, could you please explain in simpler way.

    Here is a step by step article to restore...

    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 8, 2015 at 10:04 am

    #1818345

  • RE: Every location an owner can be set

    chuck.forbes (8/7/2015)

    And so if I examine every Agent job, and none of them list a step which executes *.dstx file that resembles the "name" column from:

    select suser_sname(ownersid), 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

    August 7, 2015 at 5:03 pm

    #1818323

  • RE: Are the posted questions getting worse?

    SQLBill (8/7/2015)

    SQLRNNR (8/7/2015)

    Jeff Moden (8/7/2015)

    SQLRNNR (8/7/2015)

    jasona.work (8/7/2015)

    Another day, another "how do we prevent sysadmins from doing something" post. Which almost always boils down to essentially "we don't trust anyone,...

    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, 2015 at 5:00 pm

    #1818322

  • RE: Every location an owner can be set

    chuck.forbes (8/7/2015)

    So, I've been looking through my databases, and I was unable to find any SSIS packages until today. But now I'm a bit confused. I have been using 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

    August 7, 2015 at 3:56 pm

    #1818312

  • RE: 11.2.xxxx vs 11.0.xxxx - What is the difference?

    11.2 would be a typo.

    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, 2015 at 3:52 pm

    #1818310

  • RE: Today's Random Word!

    Mood

    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, 2015 at 3:27 pm

    #1818304

Viewing 15 posts - 961 through 975 (of 19,560 total)