Forum Replies Created

Viewing 15 posts - 2,626 through 2,640 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Sean Lange (7/17/2014)

    SQLRNNR (7/17/2014)

    The Dixie Flatline (7/16/2014)

    Woohoo!! Done with work for the evening, and in the morning we're heading to New Orleans for a long weekend. 😀 😀 :-D...

    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

    July 17, 2014 at 8:09 am

    #1730259

  • RE: Casting and Data Type Conversion

    Hany Helmy (7/17/2014)

    Jamsheer (7/15/2014)

    Thanks.. But still confused:-P.. need to work on it..

    Same confusion here, really. :w00t:

    The problem is that tinyint is an unsigned datatype (unlike smallint, int, and bigint).

    Because 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

    July 17, 2014 at 8:07 am

    #1730258

  • RE: Are the posted questions getting worse?

    Jack Corbett (7/17/2014)

    SQLRNNR (7/17/2014)

    Eirikur Eiriksson (7/16/2014)

    Jack Corbett (7/16/2014)

    Eirikur Eiriksson (7/16/2014)

    No implied either, my respect on handling the situation! So far, JC is the only one 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

    July 17, 2014 at 8:03 am

    #1730254

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (7/17/2014)

    Grant Fritchey (7/17/2014)

    Threadizens!

    Make sure we talk if you're Telford this week. The Red Gat Army is travelling up there this afternoon.

    Would that be this bunch?

    😎

    That looks eerily like...

    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

    July 17, 2014 at 7:56 am

    #1730249

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (7/16/2014)

    Jack Corbett (7/16/2014)

    Eirikur Eiriksson (7/16/2014)

    No implied either, my respect on handling the situation! So far, JC is the only one that has managed to rub me...

    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

    July 17, 2014 at 7:47 am

    #1730246

  • RE: delete large chunk of data on replicated DB

    So a total database size of 3gb is fairly small.

    With the affected rows to be roughly half of the database, that is about 1.5GB which is still pretty small.

    Take into...

    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

    July 17, 2014 at 7:45 am

    #1730244

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (7/16/2014)

    Woohoo!! Done with work for the evening, and in the morning we're heading to New Orleans for a long weekend. 😀 😀 😀 ...

    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

    July 17, 2014 at 7:34 am

    #1730243

  • RE: Today's Random Word!

    Ed Wagner (7/16/2014)

    TomThomson (7/16/2014)

    SQLRNNR (7/16/2014)

    Ed Wagner (7/16/2014)

    TomThomson (7/16/2014)

    BWFC (7/16/2014)

    Ed Wagner (7/14/2014)

    SQLRNNR (7/14/2014)

    Revenant (7/14/2014)

    Ed Wagner (7/14/2014)

    SQLRNNR (7/14/2014)

    BWFC (7/11/2014)

    Venus

    desire

    Want

    Wanton

    Pork

    Launch 😀

    Dinghy

    wherry

    Row

    Tuple

    Sequence

    Fibonacci

    spiral

    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

    July 16, 2014 at 11:52 am

    #1729980

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/16/2014)

    TomThomson (7/16/2014)

    Jack Corbett (7/16/2014)

    Steve Jones - SSC Editor (7/16/2014)

    GilaMonster (7/16/2014)

    Jeff Moden (7/15/2014)

    To be honest, I'm glad this person is taking such caution and has such FUD...

    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

    July 16, 2014 at 10:29 am

    #1729936

  • RE: best way to send emails

    Here is an article with examples

    http://jasonbrimhall.info/2011/08/15/send-dbmail/

    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

    July 16, 2014 at 9:41 am

    #1729907

  • RE: delete large chunk of data on replicated DB

    What is the size of the database?

    What is the speed of the connection between servers?

    What is the record count to be deleted?

    Those answers will help to understand a better approach.

    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

    July 16, 2014 at 9:39 am

    #1729906

  • RE: Are the posted questions getting worse?

    Jack Corbett (7/16/2014)

    SQLRNNR (7/16/2014)

    The Dixie Flatline (7/15/2014)

    Sometimes I think MVPs are a real pain in the ***. Present company excepted.

    I agree

    I wouldn't except present company 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

    July 16, 2014 at 8:51 am

    #1729887

  • RE: Today's Random Word!

    Ed Wagner (7/16/2014)

    TomThomson (7/16/2014)

    BWFC (7/16/2014)

    Ed Wagner (7/14/2014)

    SQLRNNR (7/14/2014)

    Revenant (7/14/2014)

    Ed Wagner (7/14/2014)

    SQLRNNR (7/14/2014)

    BWFC (7/11/2014)

    Venus

    desire

    Want

    Wanton

    Pork

    Launch 😀

    Dinghy

    wherry

    Row

    Tuple

    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

    July 16, 2014 at 8:45 am

    #1729881

  • RE: Is a Primary Key an index?

    sknox (7/16/2014)

    Koen Verbeeck (7/16/2014)

    Raghavendra Mudugal (7/16/2014)

    Koen Verbeeck (7/16/2014)

    Unless a clustered index was already defined. 🙂

    how you mean? "already"

    this simple statement creates a clustered index

    CREATE TABLE TT1

    (

    ID INT...

    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

    July 16, 2014 at 8:41 am

    #1729878

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (7/15/2014)

    Sometimes I think MVPs are a real pain in the ***. Present company excepted.

    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

    July 16, 2014 at 7:49 am

    #1729846

Viewing 15 posts - 2,626 through 2,640 (of 19,560 total)