![]() Using the SQL Maintenance Plan Wizard - 01:50 Having High Impact Missing Indexes - 02:59ĭemo: Finding Missing Index Warnings - 02:25ĭemo: Using the DTA Command-Line Utility - 03:40 Indexing Strategy and Maintenance - 00:49:53 Not Using T-SQL Stored Procedures - 02:56Īdditional ORM Query Considerations - 01:38 Transaction Log File Configuration - 02:57 Transaction Log File Physical Layout - 02:54 ![]() Using Default Database Properties - 04:28 Not Having a Data Archiving Strategy - 01:32ĭatabase Architecture and Design - 00:54:18ĭatabase Architecture and Design Issues - 00:59 Overuse of New SQL Server Features - 01:52ĭoing Row-by-Agonizing-Row Processing - 02:07ĭemo: Set-Based vs. User-Controlled, Long-Running Transactions - 01:19 Requesting Too Much Data from the Database 02:04 Using CLR Assemblies for Application Logic - 01:44 Using DML Triggers for Application Logic - 01:28 Too Much Business Logic in the Database - 01:22 SQL Server Scalar User-Defined Functions - 01:47 Using Ad Hoc T-SQL from the Application - 01:46 Using Diagnostic Tools to Find Bottlenecks - 03:45Īpplication Architecture and Design - 00:43:53Īpplication Architecture and Design Issues - 02:08 ![]() Postponing the Scaling Decision - 00:52:46įinding Your Bottlenecks and Improving Them - 02:18ĭemo: Sample 911 Emergency Script Part 1 - 10:52ĭemo: Sample 911 Emergency Script Part 2 - 14:38 Top Scalability Issues with SQL Server 2012 - 01:44 Largest SQL Server Implementations and Your Nightmare - 02:04 Top Scalability Issues with SQL Server 2012 - 00:10:35 Indexing Strategy and Maintenance - 03:35 Top Scalability Issues with SQL Server 2012 - 02:35Īpplication Architecture and Design Issues - 04:38ĭatabase Architecture and Design Issues - 03:10 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |