segunda-feira, março 31, 2008

A importancia de Aprender Inglês

Na área de TI sabemos que na maioria das novidades e lançamentos estão na língua Inglesa.

Por isso para que você esteja acompanhando o mercado, é essencial ter o conhecimento da língua.

Encontrei um vídeo funny


terça-feira, março 11, 2008

Monitoring Report Execution Performance with Execution Logs

Presents an excerpt from the book, Microsoft SQL Server 2005 Reporting Services Step by Step, by Stacia Misner and Hitachi Consulting. Learn how to monitor reporting services by implementing an execution logging database and reviewing reports that query that database.

More

segunda-feira, março 10, 2008

Planning for Scalability and Performance with Reporting Services

This paper consolidates general information, best practices, and tips for designing Microsoft® SQL Server™ Reporting Services reports. It is intended to provide a starting point for design questions and an overview of some of the capabilities of Reporting Services.

More

Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005

This paper explains how batches are cached and reused in SQL Server 2005, and suggests best practices on maximizing reuse of cached plans. It also explains scenarios in which batches are recompiled, and gives best practices for reducing or eliminating unnecessary recompilations.

More

Statistics Used by the Query Optimizer in Microsoft SQL Server 2005

SQL Server collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving or updating data. Microsoft has released a whitepaper that describes what data is collected where it is stored, and which commands create, updates, and delete statistics

More