Forum Replies Created

Viewing 15 posts - 19,366 through 19,380 (of 19,560 total)

  • RE: Performance issue

    argghhh - system error and a double-post

    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: Performance issue

    In addition to the recommended articles, it would also be helpful to include the sample queries, sample data, execution plans, and table structure.

    If the servers are exactly the same on...

    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: installing SQL SERVER2005 SP3 On production.

    dba-vb (9/1/2009)


    hi,

    We just planning to update the SQL server2005 with SP3, Present we have RTM. What i need to take care about this hotfix. How can...

    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: Beginning T-SQL

    sturner (9/3/2009)


    Performing a number of DBA type duties can be done sans TSQL, but I would never hire someone as a DBA managing large amounts of critical data unless they...

    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 (9/3/2009)


    Grant Fritchey (9/3/2009)Is BOL translated to languages other than English? That's the kindest explanation I can come up with.

    It is, but not having a clue what his native language...

    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: Double posting and triple posting

    Silverfox (9/2/2009)


    I have noticed a lot of double and triple posting

    http://www.sqlservercentral.com/Forums/Topic781230-149-1.aspx

    not singling out anyone :-P. I am assuming that people are using laptops and their connection is either dropping or...

    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: If you weren't a DBA what would you be doing?

    Jeff Moden (9/3/2009)


    John Rowan (9/3/2009)


    I'd be a full time parent, no questions asked.

    Heh... same as a DBA. 😛

    Yes, I have often thought of that myself. I think...

    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?

    hmmm - guess he didn't want to post his code

    http://www.sqlservercentral.com/Forums/Topic782432-146-1.aspx

    does that mean he has learned how to research the issue and troubleshoot?

    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: Mass. says "No Vendor Default PWDs"

    Can't speak about MA and the flight of companies, but CA seems to have a corporate departure.

    I know of a few companies that have left the state for other more...

    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: Squeezing the DBA

    Let's broaden this a bit. In my philosphy and ethics courses we were reminded constantly that "Legal isn't necessarily Ethical."

    Ethical is also more of a generic base of accepted...

    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?

    On behalf of myself and any others that didn't see it without your hint GSquared - thanks a lot - great laughs

    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: IF condition in CURSOR

    Paul White (9/3/2009)


    Just for completeness, this is also valid:

    -- Just to simulate some condition or other

    declare @v-2 int;

    set @v-2 = 2;

    -- Dear Lord, why am I using a cursor here?

    --...

    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: Mass. says "No Vendor Default PWDs"

    Let's throw another take on it.

    I run my business out of Mass, but use the software and services you provide - which have no physical presence in Mass. In...

    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 Agent

    If you script out the job, you should be able to see the command that is used to run it.

    dtexecui is GUI based and dtexec is cmd line based.

    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: logsize

    Could you provide us with the code that you are using to create this report?

    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 - 19,366 through 19,380 (of 19,560 total)