Many DBAs take routine database maintenance for granted. What they don’t understand is that the cumulative effect of poor database maintenance can significantly hurt performance. In this session, you will learn the key things all DBAs need to know in order to maintain their databases at peak performance.
This session will show you how to build aggregations in Analysis Services 2008 that are useful for the queries you're actually running
Best Practice Guidelines for optimal performance while using the new SQL Server 2008 features: Filtered Index/Statistics, Resource Governor, Row Compression , Page Compression, Server Configuration Option: 'optimize for ad hoc workloads', Plan Freezing, Table-Valued Parameters, Disabling Table Lock Escalation, Transparent Data Encryption and more.
A indepth insight into performance tuning database applications.
In this session I will be bringing together all the components of SQL Server to illustrate what happens when you issue a query from a client. From the TDS packet, through ODS, the optimizer and the buffer manager to returning the result. I'll walk you through when the transaction log is used, what happens when a checkpoint occurs and what the lazy writer does.
I've illustrated the process in a way that's easy to consume and helpful to put SQL Server's architecture into context.
What does it mean that my index is fragmented? Why do I get a warning about index record sizes? How should I store images in SQL Server? Knowing how SQL Server stores data and what options there are to control this can help you to build more efficient applications. In this session we will look at how table and index data is stored on disk. We will look at the various data types available, from bits to filestreams, how indexes can be used to optimize read or write performance, and how row and page compression work.
Graphical Execution Plans in SSMS is not only the best way to know what is happenning under the hood of SQL engine but also it is the most accessible one.