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.
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?
In this session we will learn about SQL Server enhancements in the most recent versions that can help you troubleshoot query performance.
A query was running fast yesterday and today it suffers from performance problems. What will you do? - restart the server (did work) - drop the procedure cache (read in a blog article) - get a coffee and pass in review this session about statistics
Martin Wild of Quest Software will lift the lid on SQL Server on Linux. He will explore the mechanics to deploy SQL Server on Linux, what is and is not in the current Linux build and share some of quirks, and observations on setup and config.
Learn about the powerful 8600 series of trace flags which additional details about how the query optimizer behaves as it processes a query.
In this session we will show you how Tabular performs when you are querying a model with many billions rows, conduct a complete analysis of the model searching for optimization ideas and implement them on the fly, so to look at the effect of using th
Learn how object-oriented T-SQL hurts performance.
  1 to 10 of 229 first 1 2 3 4 5 6 7 8 9 10  next last  Show 10 25 50 100 sessions per page