Post reply

Yaay W00t!

  • December 13, 2006 at 4:29 am

    #68559

    Got an early christmas pressie this year at work - my first production Billion Record Table!

     

    (just felt I had to share )

     

     

  • December 13, 2006 at 5:23 am

    #677728

    So... do we congratulate or send our condoleanses..?

    /Kenneth

  • December 13, 2006 at 6:26 am

    #677740

    Its nearly 130Gb so, I think condolences will be required shortly...

  • December 13, 2006 at 8:04 am

    #677777

    Sorry to burst your excitement - but you GOTTA do better than that - I have Several of these

    So how is performance for you?

  • December 13, 2006 at 8:47 am

    #677802

    'salright. 

    Putting a gig and a half a day into this table at the mo, 4 months into what looks awfully like exponential growth.

  • December 14, 2006 at 7:46 am

    #678077

    Grats on hitting that mark - Just interested , is this a data warehouse database as opposed to an OLTP one ?

    ** What you see, Depends on what you Thought, Before, You looked! **

  • December 14, 2006 at 8:09 am

    #678085

    time to start archiving then.................

  • December 14, 2006 at 1:09 pm

    #678191

    Yes, condolences will be required...sooner or later...

    I have two of them each 250+GB but they are not even 100 million...

     

    MohammedU
    Microsoft SQL Server MVP

  • December 14, 2006 at 1:40 pm

    #678202

    Condolences are definintely on the menu. We get 100 million new records per day (fairly narrow records, thankfully) in one of our tables, and I don't really wish that on anyone.

  • December 15, 2006 at 4:21 am

    #678288

    oltp it is - also quite narrow.  On the positive side there are several data streams into it that can be turned off if required - gives us a nice heads up on those horrible loadbecomingaproblem days!

     

     

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply