carga masiva | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

carga masiva

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
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 />
thanks
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.
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.
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 />
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 />
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |