Forum Replies Created

Viewing 15 posts - 16 through 30 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Ed Wagner - Tuesday, June 20, 2017 10:04 AM

    Sean Lange - Tuesday, June 20, 2017 9:35 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

    August 24, 2017 at 8:14 am

    #1956636

  • RE: Are the posted questions getting worse?

    Sean Lange - Monday, August 21, 2017 1:42 PM

    GilaMonster - Monday, August 21, 2017 1:40 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

    August 24, 2017 at 8:07 am

    #1956633

  • RE: Restore production database to other environments

    Grant Fritchey - Wednesday, August 23, 2017 12:38 PM

    Depends on where the backups are stored really. If you're backing up to your...

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

    #1956629

  • RE: What kind of technology should i use?

    miguelv06 - Wednesday, August 23, 2017 1:11 PM

    So i went ahead and setup a alwayson, created a cluster between my two servers,...

    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 23, 2017 at 1:24 pm

    #1956482

  • RE: Index creation not completed

    What is the network latency like between the two machines?

    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 23, 2017 at 11:57 am

    #1956465

  • RE: What kind of technology should i use?

    Michael L John - Wednesday, August 23, 2017 8:09 AM

    If you decide to use an availability group, you may need Enterprise edition....

    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 23, 2017 at 11:53 am

    #1956463

  • RE: Reindex maintenance plan error

    KenpoDBA - Wednesday, August 23, 2017 11:30 AM

    SQL_Hacker - Wednesday, August 23, 2017 11:13 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

    August 23, 2017 at 11:44 am

    #1956461

  • RE: Using Dynamic Query in a Transact SQL Select

    bmg002 - Wednesday, August 23, 2017 11:04 AM

    SQLRNNR - Wednesday, August 23, 2017 10:53 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

    August 23, 2017 at 11:17 am

    #1956453

  • RE: Using Dynamic Query in a Transact SQL Select

    bmg002 - Wednesday, August 23, 2017 10:40 AM

    This is likely not the best way to do it, but I think this should...

    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 23, 2017 at 10:53 am

    #1956447

  • RE: Index creation not completed

    171k rows is pretty small. Are you executing the index create from the server direct?

    Have you tried to kill the create statement?
    How long does the kill take...

    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 23, 2017 at 10:31 am

    #1956443

  • RE: Reindex maintenance plan error

    Orlando Colamatteo - Wednesday, August 23, 2017 6:15 AM

    SQLRNNR - Wednesday, August 23, 2017 12:42 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

    August 23, 2017 at 10:18 am

    #1956440

  • RE: Reindex maintenance plan error

    gtrennert - Wednesday, August 23, 2017 4:07 AM

    I will have a look to get something better, but not immediatly
    I first try to...

    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 23, 2017 at 10:05 am

    #1956436

  • RE: Byte Me: Paranormal Presence

    How do we know it was disembodied? That sounds like we are defining the null.😀

    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 23, 2017 at 12:55 am

    #1956311

  • RE: Byte Me: Killer Conference

    Reminds me of the client that said they couldn't do patching because it would break too many of their ETL consultants processes.

    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 23, 2017 at 12:53 am

    #1956310

  • RE: Byte Me: Diagnosis Data

    That's about how i feel most days.

    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 23, 2017 at 12:51 am

    #1956309

Viewing 15 posts - 16 through 30 (of 19,560 total)