Luciano [Luti] Caixeta Moreira
Microsoft MVP - SQL Server
sr. Nimbus Serviços em Tecnologia - www.srnimbus.com.br
Aviso Legal
Esta mensagem pode conter informações confidenciais e/ou privilegiadas. Se você não for o destinatário ou a pessoa autorizada a receber esta mensagem, não deve usar, copiar ou divulgar as informações nela contida ou tomar qualquer ação baseada nessas informações. Se você a recebeu indevidamente, queira, por gentileza, reenviá-la ao emitente, esclarecendo o equívoco. Este ambiente está sujeito a monitoramento.
De: michelle...@sqlpass.org [mailto:michelle...@sqlpass.org]
Em nome de Sharon Dooley
Enviada em: Tuesday, February 07, 2012 5:18 PM
Para: chapter...@listserver.sqlpass.org
Assunto: [ChapterLeaders] Announcement: PASS DBA VC Live Meeting Event Wednesday, 8 February Noon Mountain
Please share with your membership.
Thanks,
Sharon
Date: February 8, 2012
Noon Mountain Standard time -- http://www.timeanddate.com/worldclock/fixedtime.html?msg=PASS+DBA+VC+Live+Meeting+event&iso=20120208T12&p1=75
Topic: Tips for handling large data volumes
In the absence of a speaker, we will play a recording of one of the PASS Summit sessions.
Presenter: Simon Sabin
Abstract:
Tips for Handling large data volumes
• Ever tried deleting 100 million records? If you have you will know your transaction log will likely blow up, you will block all access to the table and it will generally be painful. In this session we will look at some of the techniques you can use to make this easier. We will look at how deletes and updates work and how indexes affect them, how to break the job into smaller chunks, and how to run those chunks in parallel. After this session you will understand more about why these operations are painful, what you can do to make them easier to do and reduce the impact on your end users.
• Simon Sabin is the head of data for Wonga.com, Founder of SQLBits, Microsoft Certified Master SQL Server and a Microsoft SQL Server MVP
Live Meeting Link:
https://www.livemeeting.com/cc/usergroups/join?id=JN5MP5&role=attend