Forum Replies Created

Viewing 15 posts - 7,936 through 7,950 (of 18,926 total)

  • RE: Getting RowCount of Large Table

    Here's another direction. Parsing and counting 9GB of data is always going to be more of an intensive tasks which you'll need to throw hardware at eventually.

    But after counting...

  • RE: PRINT vagaries

    Hehe, got me too. Never dreamed that '-' and '+' converts to 0. Tho it makes perfect sens when you think about it!

  • RE: What will be the output of the following?

    WayneS (6/28/2010)


    Duncan Pryde (6/28/2010)


    Changing the subject somewhat...

    Although I knew that you can have negative seeds and increments for the IDENTITY property, I've never actually used them myself.

    I'd therefore be interested...

  • RE: Insert 1,000 records in one second

    Eugene Elutin (6/28/2010)


    Ninja's_RGR'us (6/28/2010)


    Visitors are only 1 part of the equation. You still have to sell all the ads, which is harder than it seems.

    The facebook guy was...

  • RE: What will be the output of the following?

    Steve Jones - Editor (6/28/2010)


    It could be. Good catch, Kevin.

    Hey Steve did you correct Friday's question too ("SELECT @local_variable")? When I run the code I really get a,b,c and...

  • RE: Insert 1,000 records in one second

    Visitors are only 1 part of the equation. You still have to sell all the ads, which is harder than it seems.

    The facebook guy was deemed the "youngest...

  • RE: Converting a negative number

    Then please post sample data that is failing so that we can see the problem.

  • RE: repeating repeating repeating

    Nice catch... still a bug tho. I can't imagine how much wasted bandwith this is costing to host that extra useless text...

  • RE: Insert 1,000 records in one second

    PaulB-TheOneAndOnly (6/28/2010)


    Ninja's_RGR'us (6/28/2010)I was in Pass when the Lead DBA of MySpace was there to host conferences. IIRC they were handling something like 1 M queries a minute.

    Exactly. Volume...

  • RE: What will be the output of the following?

    paul.knibbs (6/28/2010)


    I think Hugo Kornelis pointed it out on page #4, but it was at the end of a lengthy post so perhaps easy to miss.

    Yup it's been pointed out...

  • RE: Converting a negative number

    Yes drop the comma. Make sure to always use the period for decimal separator. Then the convert should take.

  • RE: repeating repeating repeating

    Ya and what's the view mode you are using??

  • RE: Insert 1,000 records in one second

    Eugene Elutin (6/28/2010)


    Ninja's_RGR'us (6/28/2010)


    ...

    Just keep in mind that in most cases, logging takes far less ressources than actually showing the page(s) and querying the data to do so ;-).

    ...

    Further keep...

  • RE: Insert 1,000 records in one second

    Eugene Elutin (6/28/2010)


    By the way, my SQL Express manages to insert 10000 records into the table in around 15 milliseconds. So, if you like you can allow your web site...

  • RE: Insert 1,000 records in one second

    PaulB-TheOneAndOnly (6/28/2010)


    Ninja's_RGR'us (6/27/2010)


    Sites like myspace handle heck of a lot more than that... but still this is a nightmare to setup and maintain :w00t:.

    Agreed but, look at the infrastructure MySpace...

Viewing 15 posts - 7,936 through 7,950 (of 18,926 total)