In this session we'll understand the best practices of using this new technology. What exactly is it good for? When to use it and when NOT to?
Migration, Security, Administration and other tips and tricks.
In this session we will discuss ways to maximize existing hardware utilization to speed up queries. We will analyze cases of performance issue and tune them for better CPU, Storage and Memory utilization resulting in higher performance and lower TCO.
Learn how to monitor Analysis Services with SQL Sentry Performance Advisor. Get tips on best practices, monitoring counters and options plus improve your understanding of how Analysis Services uses memory and where it differs from SQL Server.
Large, complex queries need memory in which to work--workspace memory--and understanding the how's, when's, and why's of this memory can help you create queries that run in seconds rather than minutes.
Sometimes some piece of T-SQL slips by, or falls out of memory.Come and revisit old favorites, and brush up on new T-SQL features and enhancements.This session is chock full of code examples, including before-and-after demos and how-to illustrations.