Forum Replies Created

Viewing 15 posts - 18,316 through 18,330 (of 19,560 total)

  • RE: Case Statements

    kgbs12 (1/7/2010)


    Please, correct me if I'm wrong. If I use the @Dept within the Where clause, I would then have to declare it? Which, I don't particularly want...

    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: Best Practices for deploying a single database across multiple sites

    emily-1119612 (1/7/2010)


    >>As far as replication goes, I have read all about it

    It sounds like you know as much or more about it then me then. I wasn't sure if you...

    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: restore sql db from oracle dump

    lingaraj.sarangi (1/6/2010)


    as per my knowledge ,it is not possible to directly import .dmp file to sql server.

    we need to use a third party tool.like

    http://www.convert-in.com/ord2mss.htm

    Yes, you will need to use...

    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: Time For A View?

    In the meantime, here is some reading material

    http://technet.microsoft.com/en-us/library/ms187956.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

  • RE: Jr sql dba phone interview questions

    As Gail said, don't exaggerate yourself. You need to sell yourself, try to do it honestly. Knowing that you don't know everything will be helpful and knowing 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: Tally Table

    AndrewSQLDBA (1/6/2010)


    Hello Everyone

    I need some help with a tally table.

    I want to be able to query a list table, get the list of a few ID's and then fire off...

    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: Tally Table

    Jeff Moden (1/6/2010)


    The Tally table is not a panacea and isn't good for this. Dynamic SQL would be good for this. So would an (ugh!) cursor.

    Are you feeling...

    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: Today's Random Word!

    John Rowan (1/7/2010)


    I would gladly trade my snow shovel for shorts and t-shirts. All of the snow and cold started here the day after I returned from the Bahamas....

    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: Remote Desktop - The Joys

    I use a different app altogether for RDP. It seems to be more friendly about the double-hop thing and pinning/unpinning. Try VisionApp Remote Desktop.

    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: Women in Technology -- How about at SSC?

    Lynn Pettis (1/6/2010)


    Tell me what you think:

    Kim

    Stacey

    Shannon

    Lynn

    I have a male friend named Kim and another male acquaintance named Shannon - so I will go with male on those.

    Lynn, if it...

    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: Talking baseball

    Ray K (1/7/2010)


    CirquedeSQLeil (1/7/2010)


    Alomar - spitting is keeping him out

    Actually, I understand that Alomar has since apologized, and the umpire who was the intended target has not only forgiven him,...

    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: Being Supportive

    I think this is something that needs to be done judiciously.

    When I read the article I immediately thought of finger-pointing and back-biting putting the blame on this department or 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

  • RE: Talking baseball

    Steve Jones - Editor (1/7/2010)


    ...

    On controversial people, we should have guidelines about what the HOF means. Is it someone's life? Or their career in baseball? I don't think Rose 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

  • RE: keyset cursors

    emily-1119612 (1/7/2010)


    AndrewSQLDBA (1/5/2010)


    I believe that you should NEVER use a cursor of any type. There is always a better way.

    Andrew SQLDBA

    Hmmm...never is a strong word. For updating data I agree,...

    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: Talking baseball

    Steve Jones - Editor (1/7/2010)


    It's a little silly, and petty, by the writers. Is Alomar more deserving next year? I'm not sure the people voting are really doing a good...

    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 - 18,316 through 18,330 (of 19,560 total)