Forum Replies Created

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

  • RE: T-SQL: Why “It Depends”

    Paul White (3/16/2010)

    [font="Arial Black"]TEST IT?[/font]

    [font="Arial Black"]

    YES[/font]

    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

    March 16, 2010 at 10:56 pm

    #1134990

  • RE: Are the posted questions getting worse?

    Paul White (3/16/2010)

    Jeff Moden (3/16/2010)

    Very interesting! Apparently, I've been missing out on some good stuff because that works in 2k and 2k5. Keeping in mind that I don't...

    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

    March 16, 2010 at 10:53 pm

    #1134988

  • RE: T-SQL: Why “It Depends”

    Jeff Moden (3/16/2010)

    ith the last couple of posts in mind, I hope everyone realizes that the big brother to "It Depends" is "Test it!". 😉

    I think this needs a little...

    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

    March 16, 2010 at 10:46 pm

    #1134985

  • RE: GROUP BY in SSIS SQL Query for 35+ million rows

    Jeff Moden (3/16/2010)

    In my eyes, 20GB for such a database is probably ok but a bit large. My suggestion would be to reexamine the underlying methods and, as already...

    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

    March 16, 2010 at 10:39 pm

    #1134983

  • RE: 2 servers 1 IP

    Windows Server Enterprise edition is a requirement.

    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

    March 16, 2010 at 6:26 pm

    #1134936

  • RE: Restoring a db with more data files??

    tsduke03 (3/16/2010)

    CirquedeSQLeil (3/16/2010)

    duke-347723 (3/16/2010)

    I have a database that I need to move to another server. The server admin is giving me 4 500gb drives. I need to restore...

    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

    March 16, 2010 at 5:45 pm

    #1134927

  • RE: Are the posted questions getting worse?

    lmu92 (3/16/2010)

    Slightly off-topic:

    Anybody interested in helping me out here?

    I'm starting (already started?) to leave my comfort-zone and don't want to misguide the OP...

    I think that was a good answer.

    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

    March 16, 2010 at 5:36 pm

    #1134925

  • RE: GROUP BY in SSIS SQL Query for 35+ million rows

    Something that worked for me in the past was an 8 file tempdb. I permitted autogrowth at 512MB in each file - for the just in case scenario. ...

    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

    March 16, 2010 at 5:36 pm

    #1134924

  • RE: Restoring a db with more data files??

    duke-347723 (3/16/2010)

    I have a database that I need to move to another server. The server admin is giving me 4 500gb drives. I need to restore the 1.2...

    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

    March 16, 2010 at 4:04 pm

    #1134892

  • RE: Are the posted questions getting worse?

    tstaker (3/16/2010)

    The Dixie Flatline (3/16/2010)

    ...Gail, in ancient Geece you would have been a goddess in the Geek pantheon.

    So what you're saying is around 137 BC she'd be a goddess 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

    March 16, 2010 at 4:00 pm

    #1134887

  • RE: Career Change

    If it sounds like we are discouraging you, we aren't.

    Making the right choice is a difficult one in a position such as yours. It would be an awful situation...

    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

    March 16, 2010 at 2:57 pm

    #1134840

  • RE: Are the posted questions getting worse?

    Roy Ernest (3/16/2010)

    I got 3 rounds of back side kicking ... 🙂

    They went easy on you then 😀

    Really, it is good that you are being published for the 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

    March 16, 2010 at 2:48 pm

    #1134833

  • RE: Career Change

    GilaMonster (3/16/2010)

    If they're pressing to urgently hire, it means they are desperate, probably means they have problems that they need solving. Not a good situation to walk into as a...

    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

    March 16, 2010 at 2:47 pm

    #1134832

  • RE: Deduplication Technology & SQL Backups

    Backup expirations are configurable. The default is 30 days for files and 14 days for SQL Backups. Since we are going with the file backup version, we were...

    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

    March 16, 2010 at 2:45 pm

    #1134829

  • RE: Career Change

    If they are pressing real hard to hire someone, then something is likely breaking. You may be the best candidate they have interviewed, but maybe they are in desperate...

    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

    March 16, 2010 at 2:39 pm

    #1134822

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