Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 19,560 total)

  • RE: In which book is log shipping .wrk files mentioned?

    coolchaitu (8/5/2015)

    Sir,

    I am entry level.First, I want to gain knowledge on internals of log shipping and internals of mirroring. So,Please suggest good books to start with

    As Gail (who happens 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 5, 2015 at 1:10 pm

    #1817680

  • RE: non trusted constraints vs performance

    newbieuser (8/5/2015)

    Thank you so much.. I've generated the alter commands below to make the constraints trusted. Totally there are about 2000 alter commands, but just wondering if it is possible...

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

    #1817641

  • RE: Are the posted questions getting worse?

    Sean Lange (8/5/2015)

    Ed Wagner (8/5/2015)

    SQLRNNR (8/5/2015)

    Sean Lange (8/5/2015)

    Ed Wagner (8/5/2015)

    Jack Corbett (8/5/2015)

    I couldn't answer all the questions, but I don't expect to be able to answer every question...

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

    #1817618

  • RE: Are the posted questions getting worse?

    Sean Lange (8/5/2015)

    Ed Wagner (8/5/2015)

    Jack Corbett (8/5/2015)

    I couldn't answer all the questions, but I don't expect to be able to answer every question in an interview. I...

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

    #1817594

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/4/2015)

    SQLRNNR (8/4/2015)

    Jeff Moden (8/4/2015)

    I think before we get into interview questions, it would be much better to define what a DBA/Developer needs to be, know, and do.

    I remember...

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

    #1817591

  • RE: Are the posted questions getting worse?

    dwain.c (8/4/2015)

    SQLRNNR (8/4/2015)

    WayneS (8/4/2015)

    Sean Lange (8/4/2015)

    yb751 (8/4/2015)

    Raise your hands if you like Entity Framework...then I'll know who to shoot!

    Sorry just needed two seconds to vent. :crazy:

    I'm sure like anything else...

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

    #1817590

  • RE: CURSOR LOOP

    I liked the question. Thanks

    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, 2015 at 7:58 am

    #1817538

  • RE: Byte Me: Model Employee

    Iwas Bornready (8/5/2015)

    What came to mind for me was the dual meaning of the word modeling. I didn't read into it any deeper than that. It's sad that others still...

    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, 2015 at 7:21 am

    #1817506

  • RE: SQL Server 2012/14 - crisis - cannot connect - please help

    In addition to running the 2014 install again, I would run the developer edition install. That is unless you are going to discard those two databases afterall.

    The developer edition makes...

    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, 2015 at 6:15 am

    #1817465

  • RE: only show the duplicated records

    kennyhuang0108 (8/4/2015)

    Thank you very much Jason. None of the queries is working.

    The assignment is to exclude single LEV5 data and only show all the duplicate LEV5.

    thanks.

    Bf_ORGN_CD ...

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

    #1817364

  • RE: How to find out the list of users who has direct grant to a service account ?

    sshobha297 (8/4/2015)

    Also , is it true that Grants to service accounts should go through roles as it is against audit & compliance standards ??

    If yes, than how to find...

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

    #1817363

  • RE: Today's Random Word!

    TomThomson (8/4/2015)

    SQLRNNR (8/4/2015)

    Revenant (8/4/2015)

    Ed Wagner (8/4/2015)

    bcsims 90437 (8/4/2015)

    whereisSQL? (8/4/2015)

    Ed Wagner (8/4/2015)

    DonlSimpson (8/4/2015)

    Eirikur Eiriksson (8/4/2015)

    Ed Wagner (8/4/2015)

    SQLRNNR (8/4/2015)

    Revenant (8/4/2015)

    Ed Wagner (8/4/2015)

    bcsims 90437 (8/4/2015)

    whereisSQL? (8/4/2015)

    Ed Wagner (8/4/2015)

    DonlSimpson (8/4/2015)

    Eirikur Eiriksson (8/4/2015)

    Ed Wagner (8/4/2015)

    SQLRNNR...

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

    #1817358

  • RE: non trusted constraints vs performance

    newbieuser (8/4/2015)

    Thanks but my understanding was that only when enabling/disabling constraints needs to be created 'with check check'. Do we need to use 'with check check' when dropping...

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

    #1817356

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/4/2015)

    I think before we get into interview questions, it would be much better to define what a DBA/Developer needs to be, know, and do.

    I remember a post 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

    August 4, 2015 at 5:17 pm

    #1817355

  • RE: file server / SQL cluster

    No inter-dependencies between the two clusters?

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

    #1817342

Viewing 15 posts - 1,006 through 1,020 (of 19,560 total)