Forum Replies Created

Viewing 15 posts - 7,321 through 7,335 (of 19,560 total)

  • RE: Critical Database Backup Failing

    Good - keep us posted with your findings.

    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?

    Roy Ernest (1/2/2012)


    Our company does not own a casino. 🙂 And jason, even if you played the casino, it wont hurt the casino owners. The odds are stacked against 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

  • RE: Exact and Approximate

    Nice question. Thanks Paul.

    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: Hex Fun

    Happy New Year all!

    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: Schema Design Question - Teams

    The team table would not need to have any memberids. It should be the other way around - members table will have a teamid.

    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: How to know who truncated a SQL Server Table?

    Check this article:

    http://msdn.microsoft.com/en-us/library/dd392015.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: Sql server 2008 and Sql Server 2008 R2 are same???

    elchuru (12/30/2011)


    Hi All,

    Sql server 2008 and Sql Server 2008 R2 both are same or different

    Thanks in advance

    Different. Many things are the same, but there are plenty of additions 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: CTE Performance Compared to a Temp Table

    ChrisM@home (12/30/2011)


    TheSQLGuru (12/30/2011)


    patrickmcginnis59 (12/30/2011)


    TheSQLGuru (12/30/2011)


    I would try dropping off the PK from the table variable (note you do NOT have a temporary table here - it is a table var...

    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?

    WayneS (12/30/2011)


    Steve Jones - SSC Editor (12/30/2011)


    SQLRNNR (12/28/2011)


    How much did that barn cost? I need one that is about 60'x100'

    $100k. 72x140, Big Top Structures.

    Hmm. I think I need 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

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (12/30/2011)


    SQLRNNR (12/28/2011)


    How much did that barn cost? I need one that is about 60'x100'

    $100k. 72x140, Big Top Structures.

    Danke

    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: New Year's Eve Query

    jeff.mason (12/30/2011)


    But at least we aren't arguing whether turkey is or is not more "Christmasy" than reindeer or some such thing. Pretty much everyone knows drunkenness is a standard...

    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: Query Result in Mail

    MyDoggieJessie (12/30/2011)


    SQLRNNR (12/30/2011)


    Nah - you can delimit the results in the mailed file using

    @query_result_separator = ','

    That said, you can replace the separator value with a |, tab, or something 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

  • RE: Query Result in Mail

    JeffRush (12/30/2011)


    The problem with presenting data is that inevitably the presentation of the data comes into play 🙂

    How true that is.

    Depending on the audience, the far better solution should probably...

    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: Query Result in Mail

    Nah - you can delimit the results in the mailed file using

    @query_result_separator = ','

    That said, you can replace the separator value with a |, tab, or something else 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: help

    What have you got so far?

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