▄▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒▄
▄███▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒██▄
████▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒▓██
███ ███
███ T H E O S O P H I A ███
███ .wisdom is here. ███
███ ███
███ Proudly Presents ███
███ SQL Admin 2014: Server Optimization ███
███ ███
████▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒▓██
████▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒▓██
████▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒▓██
███ ███
███ Release notes: ███
███ ────────────── ███
███ ███
███ Date.........: November 28, 2015 ███
███ Size.........: 08x15mb ███
███ Url..........: http://is.gd/DKabI2 ███
███ Type.........: Bookware ███
███ ███
████▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒▓██
████▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒▓██
████▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒▓██
███ ███
███ Description: ███
███ ──────────── ███
███ ███
███ In this course you are going to see a few topics covering some basic ███
███ optimizing and troubleshooting in SQL Server. You will see what ███
███ Trace flags are and how they are used to alter the behavior of SQL ███
███ Server. Sometimes this is useful, sometimes it is dangerous and ███
███ sometimes it is just bizarre what they do. You will see how the use ███
███ of trace flags to capture deadlock information so you can more ███
███ efficiently troubleshoot the cause. Then you will see blocks, a ███
███ common issue in SQL Server and see how to determine which process is ███
███ blocking others and how to resolve it. Next you will then go through ███
███ a series of DMVs that are quite useful in optimizing and ███
███ troubleshooting SQL Server. Youæll see some DMV based queries used ███
███ all the time to check indexes fragmentation and usage along with a ███
███ query to identify the most expensive queries in your database. ███
███ ███
████▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒▓██
████▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒▓██
████▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒▓██
███ ███
███ Install notes: ███
███ ────────────── ███
███ ███
███ Unpack, burn/mount and go learning ███
███ ███
████▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒▓██
████▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒▓██
████▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒▓██
███ ███
███ Greetings: ███
███ ────────── ███
███ ███
███ To all the groups who brings quality - you know who you are ███
███ ███
████▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒▓██
▀███▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒██▀
▀▓▒░▒▓█████████▓▒░▒▓██████████▓▒░▒▓█████████▓▒░▒▓████████▓▒░▒▓███████▓▒░▒▀