Developing Microsoft SQL Server Databases: (06) Optimizing and Troubleshooting Queries
[MP4] [0:38:35] [2015/02/04]Learn how to tune poorly performing queries, and get tips on dealing with common performance issues and tools you can use to analyze and tune workloads.
Developing Microsoft SQL Server Databases: (05) Implementing In-Memory Objects
[MP4] [0:50:48] [2015/02/04]Find out how to implement clustered and non-clustered columnstore indexes on disk-based tables. Learn how (and when) to implement in-memory tables and stored procedures, and explore considerations for…
Developing Microsoft SQL Server Databases: (04) Managing Transactions
[MP4] [0:41:56] [2015/02/04]Get an introduction to transactions and isolation concepts, and look at how to implement transactions, catch and resolve errors, set isolation levels, and design database objects for concurrency.…
Developing Microsoft SQL Server Databases: (03) Implementing Stored Procedures and Functions
[MP4] [0:34:24] [2015/02/04]Explore implementing and executing stored procedures, including execution context, parameters, and return values. Learn about the different kinds of functions that you can create, along with how to…
Developing Microsoft SQL Server Databases: (02) Implementing Indexes
[MP4] [0:56:39] [2015/02/04]Learn the difference between heaps, clustered indexes, and non-clustered indexes. Hear how to design and implement clustered and non-clustered indexes, including considerations for filtered indexes,…
Developing Microsoft SQL Server Databases: (01) Implementing Tables and Views
[MP4] [1:22:36] [2015/02/04]Find out how to implement disk-based tables based on appropriate data types and constraints and how to implement table objects using variables, temporary tables, and common table expressions. Hear how…