SQL Server Performance

carga masiva

Discussion in 'Preguntas sobre SQL Server en Español.' started by c_maldon, Feb 9, 2006.

  1. c_maldon Member

    Tengo que llenar una base de datos con una carga masiva de BCPs a muchas tablas.
    Que metodos podría utilizar para regenerar todas las estadisticas?

    Saludos
  2. FrankKalis Moderator

    Luis is on vacation. I don't know if anyone else speaking Spanish is monitoring this forum frequently. So, you might be better off trying this time to ask in English. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  3. c_maldon Member

  4. mmarovic Active Member

    If the question is how to regenarate stastistics, then the answer is: run update statistics on tables where data are inserted immediately after bcp. It shouldn't take too much time. I hope you understand.
  5. Luis Martin Moderator

    Sip, estoy en vacaciones pero desde el Hotel en la primera parada del viaje no puedo evitar visitar el Forum.

    Luego del bcp ejecutá DBCC UPDATE STATISTICS en todas las tablas involucradas en el bcp.

    Frank and Mmrovic, thanks. Is my first stop in the travel but I can´t avoid to review spanish forum.

    The answer were the same than Mmrovic. See you in 3 or 4 days, only to check this forum.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  6. FrankKalis Moderator

    Luis, strangely addicted to this forum, hm? [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  7. mmarovic Active Member

    Luis, I hope you enjoy the vacation. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] <br /><br />Was it something like spring carneval or something like that in place you visited first?<br />You see, I like puzzles, but it is much easier to guess what is the mssql server related question then what the hell you were talking about the vacation (vacaciones) and the hotel (el hotel). [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />

Share This Page