Imagine a MySQL query that barely fits your monitor screen such as a 7 table join. This video discusses filling the gap between reading explain output and optimizing really large queries. Practical techniques used to address real-world situations are hared, while pointing out common mistakes organizations often make.
Columnstore indexes and a new, vector-based query execution method called “batch mode”, can speed up query processing in data warehouses and data marts using SQL Server 2012 by a breathtaking 10X to 100X. This talk describes how to tune indexes, queries, and load processes to help your customers get the …
This video shows off the fault tolerance and recovery properties of FoundationDB under some nasty conditions (single & multiple machine failures, network partition, full cluster power loss) on a live demo database cluster.
SQL Server has some settings which sound like a great idea but can cause major problems for performance and availability when used improperly. This video takes you on a tour of SQL Server’s most dangerous settings, from priority boost to lightweight pooling.
Learn how to improve the performance of your SQL Server database and understand when the recompilation of queries is necessary and when it is not. Understanding query compilation issues from an operational perspective requires intimate familiarity with two indispensable tools: Performance Monitor and SQL Profiler.
If you became a database administrator by rising through the ranks of software developers, you probably haven’t built your own servers from the ground up. That’s totally okay, but you’re missing some important information that will make you a better database administrator. This video will help you get started exploring …
