Forum Replies Created

Viewing 15 posts - 16,951 through 16,965 (of 19,560 total)

  • RE: Overusing Identities

    Jeff Moden (2/27/2010)

    I use identities for the same reason that people are issued SSN's... It makes life real simple as a unique identifier in the world of large batch...

    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

    February 27, 2010 at 3:39 pm

    #1126157

  • RE: Reaching for the Clouds

    I would have to agree with Tom on the security issues. We just recently had the opportunity to take some of our computing to the cloud. We are...

    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

    February 27, 2010 at 11:46 am

    #1126125

  • RE: Avoid dynamic SQL

    No Name 4 U (2/27/2010)

    Unfortunately I exercised very poor judgement.

    I reexamined the post this morning in detail and I wish that I had accepted the suggestions provided to me.

    Regrets 🙁

    I...

    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

    February 27, 2010 at 10:43 am

    #1126116

  • RE: Avoid dynamic SQL

    Welsh Corgi (2/27/2010)

    I did not mean to get personal or offend anyone.

    No excuse for being a dick... I have not been myself.

    I'm going through the toughest time 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

    February 27, 2010 at 9:55 am

    #1126108

  • RE: Are the posted questions getting worse?

    Paul White (2/27/2010)

    GilaMonster (2/27/2010)

    Someone is a little over-sensitive to corrections and disagreements. Not just that thread, several previous ones too.

    I had noticed that too, but thought 'Welsh Corgi' had improved...

    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

    February 27, 2010 at 9:50 am

    #1126107

  • RE: Identity field on each table

    Paul White (2/27/2010)

    GilaMonster (2/26/2010)

    It's common, but it doesn't have to be int. As far as I know, any numeric data type will work

    You can use decimal, int, numeric, smallint, bigint,...

    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

    February 27, 2010 at 9:39 am

    #1126105

  • RE: Are the posted questions getting worse?

    Sad when they just won't relent - just keep pushing it. Not 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

    February 26, 2010 at 11:13 pm

    #1125994

  • RE: Are the posted questions getting worse?

    Paul White (2/26/2010)

    CirquedeSQLeil (2/26/2010)

    Jeff Moden (2/26/2010)

    I guess I'd get into trouble if I recommended that someone started Lithium treatment, huh?

    http://www.sqlservercentral.com/Forums/Topic873721-145-1.aspx

    Probably, but didn't you just make that recommendation 😀

    And you just...

    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

    February 26, 2010 at 11:08 pm

    #1125989

  • RE: Are the posted questions getting worse?

    Jeff Moden (2/26/2010)

    I guess I'd get into trouble if I recommended that someone started Lithium treatment, huh?

    http://www.sqlservercentral.com/Forums/Topic873721-145-1.aspx

    Probably, but didn't you just make that recommendation 😀

    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

    February 26, 2010 at 10:54 pm

    #1125983

  • RE: With 3 years experience in SQL Server DBA.

    Alvin Ramard (2/26/2010)

    I would not recommend coming to the US becuase more and more of the IT work here is being outsourced to India.

    I would agree with this statement.

    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

    February 26, 2010 at 10:36 pm

    #1125976

  • RE: FizzBuzz

    Tom.Thomson (2/26/2010)

    CirquedeSQLeil (2/26/2010)

    Thanks for doing that. I will test it out and see how it works. Do you mind if I use this code for an article (blog...

    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

    February 26, 2010 at 9:46 pm

    #1125951

  • RE: two databases...same name...same instance...is it psbl?

    Jeff Moden (2/26/2010)

    iqtedar (2/26/2010)

    ...which way do you want to skin this cat? 😉

    Sounds like a monty python leadin ;-);-)

    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

    February 26, 2010 at 9:43 pm

    #1125949

  • RE: FizzBuzz

    Jeff Moden (2/26/2010)

    Jason... you might also want to try Gianluca's enhancement with the original "seed" using UNPIVOT. Between what he came up with, your original work, and Tom's enhancement,...

    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

    February 26, 2010 at 9:42 pm

    #1125948

  • RE: Who changed the file growth settings?

    Electrix (2/26/2010)

    Thanks for the help

    You're welcome

    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

    February 26, 2010 at 9:39 pm

    #1125946

  • RE: FizzBuzz

    Tom.Thomson (2/26/2010)

    I can cut somewhere between 0.2 and 4 per cent off the elapsed time at 150000000 rows for Jason's method (but limiting scalability to 4 billion rows instead of...

    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

    February 26, 2010 at 5:36 pm

    #1125876

Viewing 15 posts - 16,951 through 16,965 (of 19,560 total)