Tags
Content Type
Search
The SQL team has been working on next-gen query processing improvements to improve the performance of your queries and to enable new scenarios. This talk will explain these enhancements and how they fit into the overall product roadmap for SQL.
Indexes are essential to good database performance, but it can be hard to decide what indexes to create. In this session we'll look at the design considerations for clustered indexes and for nonclustered indexes.
Not every workload can benefit from In-Memory tables. Memory Optimized Tables are not a magic bullet that will improve performance for all kinds of transactional workloads. This session gives you the details you need.
In this demo-intensive session you will discover how to capture a meaningful workload in production and how to replay it against your test system.
In this session you will learn how to use Extended Events and Dynamic Management Views (DMVs) to build a performance-monitoring system for your database environment.
Have you ever considered a situation where Columnstore Index can be quite the opposite of what one expect from it? A slow, wasteful source of painfully slow queries, lagging the performance, consuming irresponsible amount of resources ...
With increasing speed in relational query execution classical analytical solutions get challenged more and more. Why loose time for processing data into multi-dimensional databases? Why analyze outdated data if you can have fresh data instead?
Data architects and DBAs have debated database design best practices for decades. Join us for some great debates and laughs.
SQL Server normally relies on concurrency models in order to maintain the Isolation in ACID. As systems scale, this method can go from being a benefit to a hindrance, limiting the concurrency for our applications and hurting performance.
It just works – performance and scale in SQL Server 2016 database engine and what is being added to in-market versions.
  1 to 10 of 302 first 1 2 3 4 5 6 7 8 9 10  next last  Show 10 25 50 100 sessions per page