Forum Replies Created

Viewing 15 posts - 2,281 through 2,295 (of 19,560 total)

  • RE: Today's Random Word!

    Revenant (8/12/2014)


    Ed Wagner (8/11/2014)


    djj (8/11/2014)


    SQLRNNR (8/11/2014)


    crookj (8/11/2014)


    Ed Wagner (8/11/2014)


    SQLRNNR (8/11/2014)


    charitable

    Donation

    Time (the most valuable asset)

    self

    serving

    Others

    Otters

    oyster

    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

  • RE: Pythian is hiring! - Expert-level SQL Server Database Consultant

    rogers 62092 (8/12/2014)


    Sorry for the confusion, folks.... it is fixed now. That line should have SQL Server rather than Oracle.

    Phew - that is much better:cool:

    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

  • RE: Formatting result set

    Seems like a pivot would probably work for what you have described.

    You can see an example here. http://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

    With a table structure (ddl) and more consumable data, somebody could probably help...

    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

  • RE: System SPID 17 blocks after SSIS Load

    Good info. Thanks for posting back with your resolution.

    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

  • RE: Pythian is hiring! - Expert-level SQL Server Database Consultant

    LutzM (8/12/2014)


    nah - they probably want somebody to do both.

    If that's the case, why isn't Oracle listed as a required qualification?

    Or do you mean they're asking for a SQL Server...

    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

  • RE: Pythian is hiring! - Expert-level SQL Server Database Consultant

    LutzM (8/12/2014)


    That's weird:

    RESPONSIBILITES:

    Provide support to external clients on all aspects of Oracle Database Management, including but not limited to:...

    and

    QUALIFICATIONS: Highly experienced in Database design and Administration performing the following:

    • Expert...

    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

  • RE: SQL book for a beginner? -need suggestions

    http://www.amazon.com/Server-2012-T-SQL-Recipes-Problem-Solution/dp/1430242000

    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

  • RE: InvestmentType == "Forward Cash"

    ronan.healy (8/12/2014)


    how if im using an sql script

    Nothing was said about using a SQL Script (exeucte sql component). Your data source (ole db source) can use a sql statement/query...

    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

  • RE: SQL Server express replication

    If you need replication, why not just upgrade and get a SQL Server Standard edition license?

    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

  • RE: Career future , stay or switch

    daniarchitect (8/12/2014)


    I like what I do , but don't get me wrong I want to make more money while the time is right:) . that's why move to different technology...

    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

  • RE: InvestmentType == "Forward Cash"

    ronan.healy (8/12/2014)


    will have to declare a variable for it to work

    No, you just map the datasource column to the CurrencyCodePurchased column in your destination object.

    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

  • RE: Are the posted questions getting worse?

    Ed Wagner (8/12/2014)


    jasona.work (8/12/2014)


    So we had some torrential rain yesterday (up to 6" in some places in a couple hours, more than double the normal rainfall for August) Roads...

    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

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/12/2014)


    Beatrix Kiddo (8/12/2014)


    Tweeting about my mistake. I was only trying to help. I didn't suggest doing anything dangerous.

    Well, I know at least one person who is totally lost...

    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

  • RE: Are the posted questions getting worse?

    GilaMonster (8/12/2014)


    So three days after implementing replication, I have a pile or replication-related errors on my desk (cannot truncate table because it's replicated, lob size exceeds max replicated text size)

    How...

    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

  • RE: Career future , stay or switch

    SQL Developers can go quite a ways - depending on their skill set. Just the same as with the other technologies - it depends on your ability.

    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

Viewing 15 posts - 2,281 through 2,295 (of 19,560 total)