What Makes a Good Data Scientist? – http://wp.me/p1AMkl-S3
SQL SERVER – Database source control with ApexSQL software – http://wp.me/p2NUQ-8ef
Business Intelligence Week :: Você está convidado a participar! – http://wp.me/p1fbTz-ky
Resultado da enquente – Qual a ferramenta mais utilizada para monitorar seu ambiente? – http://wp.me/p15Ot5-np
Estatísticas de banco de dados, vale a pena cuidar :)
Publicado originalmente em Journey to SQL Authority with Pinal Dave:
[Note from Pinal]: This is a 83rd episode of Notes from the Field series. Maintenance of the database is very critical activity and I have always seen DBA taking it very seriously. There is a only one problem – there is no single solution or guidance for how to maintain the database. Everybody has their own opinion and way to do different tasks. Statistics is one of the most important aspect of the database. The performance of entire application can depend on statistics, as it can help SQL Engine with intelligence to execute optimal plan.
In this episode of the Notes from the Field series database expert Stuart Ainsworth explains about basic statistics maintenance.
Statistic maintenance is an important (but often overlooked) aspect of performance tuning for SQL Server. The query optimizer relies on distribution statistics to determine how the query will be executed, with a particular emphasis on SEEKS vs…
Ver original 691 mais palavras