Forum Replies Created

Viewing 15 posts - 3,496 through 3,510 (of 19,560 total)

  • RE: Understanding Graphical Execution Plans - Part 3: Analyzing the Plan

    Nice job Darren.

    Nice clarifications by Grant.

    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

    February 26, 2014 at 11:06 pm

    #1692531

  • RE: Understanding Graphical Execution Plans - Part 3: Analyzing the Plan

    OldCursor (2/25/2014)

    Thanks Grant

    Now . . . if you enjoy it so much perhaps you could pop round and sort out my clients problems - it would save all 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

    February 26, 2014 at 11:06 pm

    #1692530

  • RE: Today's Random Word!

    Ed Wagner (2/26/2014)

    crookj (2/26/2014)

    Ed Wagner (2/26/2014)

    Stuart Davies (2/26/2014)

    BWFC (2/26/2014)

    Ed Wagner (2/24/2014)

    Daniel Bowlin (2/24/2014)

    SQLRNNR (2/24/2014)

    Ed Wagner (2/24/2014)

    crookj (2/24/2014)

    BWFC (2/24/2014)

    SQLRNNR (2/21/2014)

    BWFC (2/21/2014)

    SQLRNNR (2/21/2014)

    dingleberry

    Clinker

    Klink

    Jail

    Bail

    Water

    board

    surf

    Surf and turf

    Shrimp

    potted

    Plant

    Magnolia

    Yosemite Sam

    handlebar

    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

    February 26, 2014 at 7:34 am

    #1692273

  • RE: Intersecting - 1

    Thanks Ron

    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

    February 26, 2014 at 12:09 am

    #1692141

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/25/2014)

    Last night home. Start my journey back to Afghanistan Tuesday morning.

    Good luck and safe travels.

    Hope it was a good time back home.

    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

    February 25, 2014 at 7:41 am

    #1691885

  • RE: Unable to attach MDF File to sql server

    The error says you have a database already attached with that name.

    Is that true?

    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

    February 25, 2014 at 7:38 am

    #1691881

  • RE: Auditing Matters

    Gary Varga (2/24/2014)

    I found that reading a couple of books on hacking in general (i.e. hacking networks, systems, databases, applications, etc.) really helped open my eyes to a new way...

    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

    February 24, 2014 at 10:28 am

    #1691655

  • RE: Denying DML operations from another server

    Lowell (2/24/2014)

    SQLHeap (2/24/2014)

    SQLRNNR (2/24/2014)

    The best method for that is to have the prod database servers segmented away from the dev servers via firewall/router. Then have firewall rules preventing access...

    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

    February 24, 2014 at 9:26 am

    #1691620

  • RE: Denying DML operations from another server

    SQLHeap (2/24/2014)

    SQLRNNR (2/24/2014)

    The best method for that is to have the prod database servers segmented away from the dev servers via firewall/router. Then have firewall rules preventing access between...

    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

    February 24, 2014 at 9:12 am

    #1691607

  • RE: Need to add new subsciber database with different tables replication

    p.swathi4 (2/24/2014)

    First subscriber database will be used by HR team and the new subscriber database will be used by Finance team. So 2 different teams will be using the different...

    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

    February 24, 2014 at 9:09 am

    #1691604

  • RE: Need to add new subsciber database with different tables replication

    With the same publisher database - sure that is possible. But, that means that both subscriber databases would get all of the tables (if you use the same publication).

    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

    February 24, 2014 at 7:54 am

    #1691567

  • RE: Denying DML operations from another server

    The best method for that is to have the prod database servers segmented away from the dev servers via firewall/router. Then have firewall rules preventing access between dev and...

    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

    February 24, 2014 at 7:52 am

    #1691565

  • RE: wait stats precentage?

    In short, look at the PCT column.;-)

    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

    February 24, 2014 at 7:46 am

    #1691561

  • RE: Need to add new subsciber database with different tables replication

    With a different database, you will need to create a new publication and a new subscription.

    If they need it to be more real time, you will likely need to do...

    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

    February 24, 2014 at 7:45 am

    #1691559

  • RE: Today's Random Word!

    Ed Wagner (2/24/2014)

    crookj (2/24/2014)

    BWFC (2/24/2014)

    SQLRNNR (2/21/2014)

    BWFC (2/21/2014)

    SQLRNNR (2/21/2014)

    dingleberry

    Clinker

    Klink

    Jail

    Bail

    Water

    board

    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

    February 24, 2014 at 7:34 am

    #1691553

Viewing 15 posts - 3,496 through 3,510 (of 19,560 total)