In this session, we are going to explain and test different DW features in SQL Server 2012, including star join optimization through bitmap filters, table partitioning, window functions, columnstore indices and more.
An in-depth dive into physical table structures
This session looks at some of the different methods available to load slowly changing dimension data into a data warehouse, and compares the relative performance given different data scenarios and traditional storage compared with FusionIO
The fill-factor index option has a huge impact on the performance of your DB. By using a different approach for specific use cases this session will give you the tools to find the most optimal fill-factor for your tables.
Snapshots without snapshots...is that possible? Take a "Classic" snapshot fact table, add some temporal data theory and you'll get a new fact table than can store snapshot data without doing snapshots. A life saver when you have a lot of data.
SQL Server optimizer doesn't use and index seek for execution of your query although the query is high selective? What is better, when and why: LIKE vs: SUBSTRING, IN vs. EXISTS, SUBQUERY vs. JOIN. Why you should not use the UPPER or LOWER functions?
It's Friday, 05:00pm. You are just receiving an email that informs you that your SQL Server has enormous performance problems! What can you do? How can you identify the problem and resolve it fast?
This session will take a look at query plan operators, what they are, what they each do, why they get chosen and also how to avoid using them when they perform badly. This will be held mainly in management studio with lots of examples
It's important to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. This session will show you how to use PowerShell to gather your baseline and how to report it.
How do you do database maintenance in an enterprise environment? In this session I will go through how you can do backup, integrity check, index and statistics maintenance using Ola Hallengren's Maintenance Solution.
Service Broker was introduced in SQL Server 2005 to provide asyncronous messaging in your database applications. In this session we'll walk you through the basics of Service Broker and show how you can use it to build highly scalable applications.
This session will explore a handful of T-SQL practices - why they happen, why they're bad, and how we can work around them.
In this section we will show how to avoid performance problems caused by poor query design (functions in WHERE clause, data type conversions…) and explain how local variables and parameters affect the generation of execution plan.
This session will be presented jointly by Justin Langford and Gavin Payne . The focus of the session is the approach to a cross-team Performance Troubleshooting engagement where multiple stakeholders were involved.
Cube tuning is a key part of any BI project and it gets more so as cubes get bigger. Here are a series of tuning procedures to follow for cubes large and small.
Do you already wanted to know how SQL Server 2008 stores a database file physically on the hard drive? In this session you will learn the internal structure of a SQL Server 2008 database file.
Writing your first SSIS custom components can seem like a very steep learning curve. In this session i shall walk you through a simple skeletal one to start you on your way.
With SQL Server you can integrate traditional tools such as SQL profiler and performance monitor to pinpoint problems. With SQL Server 2008, you can control environments using Policy based management and with the Resource Governor. Chris will explore
If you want to see DBAs fight - ask them what is better: using IDs or native keys?
This old debate has been troubling database designers since the days of Dr. Codd and Chris Date.
Are you ready to hear the "truth"?
See how the optimiser chooses the operators it does through real world examples.
A look at the basics of CLR integration with SQL Server, focusing on the nuts and bolts of CLR objects, followed by some practical examples.
Transaction Replication is a widely used feature in SQL Server though its internals are sparsely understood.
In this session we will look under the hood and gain indepth understanding about Transactional Replication architecture and its corresponding components like logreader and distribution agents, Reader/Writer threads, etc. We will learn methods of identifying and monitoring replication latency and methods of troubleshooting and eliminating bottlenecks to improve Replication Performance.
An overview of some everyday TSQL tuning techniques.
A challenge to traditional patterns of processing, storing and retrieving the precious data that we are responsible for
Learn to tune Analysis Services 2008 query performance
A typical day of DBA and new features of SQL Server 2008 can help - save a minute.
Bad performance is often systemic of poor queries which are systemic of bad schema design which is systemic of non-relational thinking which is systemic of project time constraints and lack of understanding of Database Design. In this talk/tutorial I'll work my way through Normalisation, we'll look at the Relation Model and how to think in sets - it's very important; throughout I'll be referring to Codd and Date's teachings. Theory aside I'll do all my demonstrations in SQL Server - concurrency, indexing, good T-SQL practices and advice.
This session aims to enlighten the audience on improving Log file design, implementation and management for extracting maximum performance from SQL Server using real world examples and strategy. The session will focus on SQL Server 2005, SQL Server 2008 and SQL 2008 R2.
Learn how the Analysis Services cache works, and how you can pre-load it with data to ensure optimal query performance.
So you heard about the new spatial functionality in SQL Server 2008, rushed back to your database and added geography and geometry columns to all your tables, eager to create the next Google Earth-beating application. You then click the Execute button and wait.
And wait some more. (You get the idea).
Spatial data is a rather unique beast, and designing efficient spatial queries requires specific techniques when compared to other, more traditional types of data.
In this session, we look at how the SQL Server database engine satisfies spatial queries, the theory behind spatial indexes, demonstrate the effects of altering the bounding box, use the spatial system DMVs and stored procedures to your spatial database