{"id":36773,"date":"2022-12-21T01:00:01","date_gmt":"2022-12-21T05:00:01","guid":{"rendered":""},"modified":"2022-12-21T23:18:49","modified_gmt":"2022-12-22T03:18:49","slug":"script-coding-sql-server-performance-essentials-ndash-full-course","status":"publish","type":"post","link":"https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/","title":{"rendered":"[#Script #Coding] SQL Server Performance Essentials &ndash; Full Course"},"content":{"rendered":"<div align=\"center\" style=\"padding: 2%;\"><iframe loading=\"lazy\" title=\"SQL Server Performance Essentials \u2013 Full Course\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/HvxmF0FUwrM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/div>\n<blockquote style=\"text-align: left; background-color: #E4E4E4; border: 3px dotted gray; padding:2%;\"><p>\n<a href=\"https:\/\/www.youtube.com\/watch?v=HvxmF0FUwrM\" target=\"offsite\" rel=\"nofollow noopener noreferrer\"><\/a><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=HvxmF0FUwrM\" target=\"offsite\" rel=\"nofollow noopener noreferrer\"><\/a><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=HvxmF0FUwrM\" target=\"offsite\" rel=\"nofollow noopener noreferrer\"><\/p>\n<h3>SQL Server Performance Essentials \u2013 Full Course<\/h3>\n<p><\/a><a href=\"https:\/\/www.youtube.com\/watch?v=HvxmF0FUwrM\" target=\"offsite\" rel=\"nofollow noopener noreferrer\"><\/a><a href=\"https:\/\/www.youtube.com\/watch?v=HvxmF0FUwrM\" target=\"offsite\" rel=\"nofollow noopener noreferrer\"><\/a>By <a href=\"https:\/\/www.youtube.com\/channel\/UC8butISFwT-Wl7EV0hUK0BQ\" target=\"offsite\" rel=\"nofollow noopener noreferrer\"><strong>freeCodeCamp.org<\/strong><\/a><br \/>\n<strong>Published<\/strong>: May 17, 2022<\/p>\n<p><em style=\"font-family: 'Times New Roman',Times,serif; color: #666;\"><span style=\"font-size: 3.5em; font-weight: bold;\">\u201c<\/span><\/em><br \/>\n<a href=\"https:\/\/www.youtube.com\/watch?v=HvxmF0FUwrM\" target=\"offsite\" rel=\"nofollow noopener noreferrer\"><img decoding=\"async\" src=\"https:\/\/i1.ytimg.com\/vi\/HvxmF0FUwrM\/hqdefault.jpg\" class=\"alignright\" align=\"right\" alt=\"freeCodeCamp.org\" style=\"width: 200px; height: auto;\"\/><\/a> In this course, Essentials of SQL Server Performance For Every Developer, you will see how to diagnose what is happening with a slow running SQL statement and what strategies are available to make these statements run faster.<\/p>\n<p>By the end of this course, you as an application developer will have the tools you need to troubleshoot performance problems you may encounter when using SQL Server.<\/p>\n<p>Code, links, Dynamic Views(DMVs), and Database Backups: <a href=\"https:\/\/github.com\/iCodeMechanic\/Essentials-of-Sql-Server-Performance-for-Every-Developer\" target=\"offsite\" rel=\"nofollow noopener noreferrer\">https:\/\/github.com\/iCodeMechanic\/Esse&#8230;<\/a><\/p>\n<p>Course from Rajan Arora. Check out his channel: <a href=\"https:\/\/www.youtube.com\/c\/ICodeMechanic\" target=\"offsite\" rel=\"nofollow noopener noreferrer\">https:\/\/www.youtube.com\/c\/ICodeMechanic<\/a><\/p>\n<ul><strong>Course Contents<\/strong><\/p>\n<li>(0:00:00) Introduction<\/li>\n<\/ul>\n<ul><strong>Getting Started<\/strong><\/p>\n<li>(0:00:53) 1.1 Course Introduction<\/li>\n<li>(0:04:07) 1.2 Why Developers should Understand SQL Performance<\/li>\n<li>(0:06:20) 1.3 Tools you Need<\/li>\n<li>(0:09:30) 1.4 Restore the Sample Database<\/li>\n<li>(0:12:04) 1.5 Table Concept<\/li>\n<li>(0:17:12) 1.6 Index Concept<\/li>\n<li>(0:20:32) 1.7 Summary<\/li>\n<\/ul>\n<ul><strong>Analyzing SQL Statements for Performance<\/strong><\/p>\n<li>(0:22:12) 2.1 Introduction<\/li>\n<li>(0:24:55) 2.2 Understanding How SQL Server Will Execute a SQL Statement<\/li>\n<li>(0:29:33) 2.3 Reading and Interpreting an Execution Plan for a SQL Statement<\/li>\n<li>(0:39:44) 2.4 Getting Execution Statistics for a SQL Statement<\/li>\n<li>(0:45:29) 2.5 Improving Statement Performance by Adding an Index<\/li>\n<li>(0:52:11) 2.6 Rewriting SQL Statements for Improved Performance<\/li>\n<li>(0:58:32) 2.7 Common Execution Plan Operations<\/li>\n<li>(1:03:50) 2.8 Summary<\/li>\n<\/ul>\n<ul><strong>Building Indexes<\/strong><\/p>\n<li>(1:07:30) 3.1 Introduction<\/li>\n<li>(1:09:09) 3.2 Index Terminology Refresher<\/li>\n<li>(1:12:11) 3.3 What Should I Index in My Database?<\/li>\n<li>(1:16:16) 3.4 Why Index Column Order Matters<\/li>\n<li>(1:23:39) 3.5 Index Selectivity Explained<\/li>\n<li> (1:36:23) 3.6 LIKE Clauses and Index Selectivity<\/li>\n<li>(1:40:27) 3.7 How Functions in the WHERE Clause Affect Indexes<\/li>\n<li>(1:46:10) 3.8 Include Columns and Covering Indexes<\/li>\n<li>(1:50:40) 3.9 Over-indexing<\/li>\n<li>(1:54:40) 3.10 Interpreting SQL Server Index Recommendations<\/li>\n<li>(1:57:38) 3.11 Summary<\/li>\n<\/ul>\n<ul><strong>Finding Bottlenecks in SQL Server Performance<\/strong><\/p>\n<li>(2:03:19) 4.1 Introduction<\/li>\n<li>(2:08:36) 4.2 Getting Information About SQL Server Sessions and Resource Usage<\/li>\n<li>(2:12:02) 4.3 Finding What SQL Statements are Currently Executing<\/li>\n<li>(2:18:47) 4.4 Finding the Slowest, Most Expensive SQL Statements<\/li>\n<li>(2:24:13) 4.5 Getting SQL Server&#8217;s Recommendations on Missing Indexes<\/li>\n<li>(2:29:38) 4.6 Finding Indexes That are Not Being Used<\/li>\n<li>(2:34:13) 4.7 Summary<\/li>\n<\/ul>\n<ul><strong>Capturing Trace Logs of Application from SQL Server<\/strong><\/p>\n<li>(2:35:55) 5.1 Introduction<\/li>\n<li>(2:42:03) 5.2 Setting up a SQL Profiler Trace<\/li>\n<li>(2:49:59) 5.3 Running a SQL Profiler Trace<\/li>\n<li>(2:55:22) 5.4 Running a Trace as a Server Side Trace<\/li>\n<li>(3:03:19) 5.5 Introduction to Using Extended Events for SQL Tracing<\/li>\n<li>(3:06:58) 5.6 Setting up an Extended Events Trace Session<\/li>\n<li>(3:16:50) 5.7 Running and Configuring the Display Settings for an Extended Events Trace<\/li>\n<li>(3:20:38) 5.8 Analyzing Extended Events Trace Data<\/li>\n<li>(3:27:10) 5.9 Using Extended Events in SQL Azure<\/li>\n<li>(3:31:36) 5.10 Summary<\/li>\n<\/ul>\n<ul><strong>Apply Common Practices for Better Performance<\/strong><\/p>\n<li>(3:35:47) 6.1 Introduction<\/li>\n<li>(3:37:17) 6.2 Use Parameterized SQL<\/li>\n<li> (3:42:59) 6.3 Are Stored Procedures Faster Than SQL in Application Code?<\/li>\n<li>(3:43:04) 6.4 Commit Behavior and Performance<\/li>\n<li>(3:50:16) 6.5 Object Relational Mappers Just Generate SQL<\/li>\n<li>(3:53:19) 6.6 Solving the N+1 Selects Problem<\/li>\n<li>(3:59:56) 6.7 Summary<\/li>\n<div style=\"text-align: center; font-weight: bold\">[<a href=\"https:\/\/www.youtube.com\/watch?v=HvxmF0FUwrM\" target=\"offsite\" rel=\"nofollow noopener noreferrer\" title=\"Read More on YouTube\">READ MORE<\/a>]<\/div>\n<p><em style=\"font-family: 'Times New Roman',Times,serif; color: #666;\"><span style=\"font-size: 3.5em; font-weight: bold;\">\u201d<\/span><\/em><\/ul>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>In this course, Essentials of SQL Server Performance For Every Developer, you will see how to diagnose what is happening with a slow running SQL&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[109,380],"tags":[2260,1756,2611,2453,2612],"class_list":["post-36773","post","type-post","status-publish","format-standard","hentry","category-scripting-and-coding","category-video-tutorials","tag-developer","tag-freecodecamp","tag-rajan-arora","tag-server","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>[#Script #Coding] SQL Server Performance Essentials &ndash; Full Course - WHUZZUP!<\/title>\n<meta name=\"description\" content=\"In this course, Essentials of SQL Server Performance For Every Developer, you will see how to diagnose what is happening with a slow running\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[#Script #Coding] SQL Server Performance Essentials &ndash; Full Course - WHUZZUP!\" \/>\n<meta property=\"og:description\" content=\"In this course, Essentials of SQL Server Performance For Every Developer, you will see how to diagnose what is happening with a slow running\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/\" \/>\n<meta property=\"og:site_name\" content=\"WHUZZUP!\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/EricBrooksDotComWeb\/\" \/>\n<meta property=\"article:author\" content=\"EricBrooksDotComWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-21T05:00:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-22T03:18:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i1.ytimg.com\/vi\/HvxmF0FUwrM\/hqdefault.jpg\" \/>\n<meta name=\"author\" content=\"Eric Brooks\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@EricBrooksCom\" \/>\n<meta name=\"twitter:site\" content=\"@EricBrooksCom\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Eric Brooks\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/script-coding-sql-server-performance-essentials-ndash-full-course\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/script-coding-sql-server-performance-essentials-ndash-full-course\\\/\"},\"author\":{\"name\":\"Eric Brooks\",\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/#\\\/schema\\\/person\\\/3b162468e1f9814f6e9f61460db00a3a\"},\"headline\":\"[#Script #Coding] SQL Server Performance Essentials &ndash; Full Course\",\"datePublished\":\"2022-12-21T05:00:01+00:00\",\"dateModified\":\"2022-12-22T03:18:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/script-coding-sql-server-performance-essentials-ndash-full-course\\\/\"},\"wordCount\":390,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/script-coding-sql-server-performance-essentials-ndash-full-course\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i1.ytimg.com\\\/vi\\\/HvxmF0FUwrM\\\/hqdefault.jpg\",\"keywords\":[\"Developer\",\"freecodecamp\",\"Rajan Arora\",\"Server\",\"SQL\"],\"articleSection\":[\"Scripting and Coding\",\"Video Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/script-coding-sql-server-performance-essentials-ndash-full-course\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/script-coding-sql-server-performance-essentials-ndash-full-course\\\/\",\"url\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/script-coding-sql-server-performance-essentials-ndash-full-course\\\/\",\"name\":\"[#Script #Coding] SQL Server Performance Essentials &ndash; Full Course - WHUZZUP!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/script-coding-sql-server-performance-essentials-ndash-full-course\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/script-coding-sql-server-performance-essentials-ndash-full-course\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i1.ytimg.com\\\/vi\\\/HvxmF0FUwrM\\\/hqdefault.jpg\",\"datePublished\":\"2022-12-21T05:00:01+00:00\",\"dateModified\":\"2022-12-22T03:18:49+00:00\",\"description\":\"In this course, Essentials of SQL Server Performance For Every Developer, you will see how to diagnose what is happening with a slow running\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/script-coding-sql-server-performance-essentials-ndash-full-course\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/script-coding-sql-server-performance-essentials-ndash-full-course\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/script-coding-sql-server-performance-essentials-ndash-full-course\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i1.ytimg.com\\\/vi\\\/HvxmF0FUwrM\\\/hqdefault.jpg\",\"contentUrl\":\"https:\\\/\\\/i1.ytimg.com\\\/vi\\\/HvxmF0FUwrM\\\/hqdefault.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/script-coding-sql-server-performance-essentials-ndash-full-course\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[#Script #Coding] SQL Server Performance Essentials &ndash; Full Course\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/#website\",\"url\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/\",\"name\":\"WHUZZUP!\",\"description\":\"What&#039;s new at EricBrooks.Com plus news and gossip all over CyberTown\",\"publisher\":{\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/#organization\",\"name\":\"WHUZZUP!\",\"url\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/ericbrooks.com\\\/images\\\/posts\\\/cropped-favicon_64-1.png\",\"contentUrl\":\"https:\\\/\\\/ericbrooks.com\\\/images\\\/posts\\\/cropped-favicon_64-1.png\",\"width\":512,\"height\":512,\"caption\":\"WHUZZUP!\"},\"image\":{\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/EricBrooksDotComWeb\\\/\",\"https:\\\/\\\/x.com\\\/EricBrooksCom\",\"https:\\\/\\\/www.instagram.com\\\/ericbrooksdotcom\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/ericbrooksdotcom\",\"https:\\\/\\\/myspace.com\\\/ericbrooksdotcom\",\"https:\\\/\\\/www.pinterest.com\\\/ericbrookscom\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/ericbrooksdotcom\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/#\\\/schema\\\/person\\\/3b162468e1f9814f6e9f61460db00a3a\",\"name\":\"Eric Brooks\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/62114f8baf9a3737e7686125b69907010ad6aff5dfc07c12707e8a18bb49bc34?s=96&d=blank&r=x\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/62114f8baf9a3737e7686125b69907010ad6aff5dfc07c12707e8a18bb49bc34?s=96&d=blank&r=x\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/62114f8baf9a3737e7686125b69907010ad6aff5dfc07c12707e8a18bb49bc34?s=96&d=blank&r=x\",\"caption\":\"Eric Brooks\"},\"description\":\"Web &amp; Graphic Designer, Blogger, Musician, Evil Clown. I also code websites and promote people for a living. Still kind of a jerk, though. Approach with food.\",\"sameAs\":[\"https:\\\/\\\/ericbrooks.com\",\"EricBrooksDotComWeb\",\"ericbrooksdotcom\",\"ericbrookscom\\\/\",\"https:\\\/\\\/x.com\\\/EricBrooksCom\"],\"url\":\"https:\\\/\\\/ericbrooks.com\\\/whuzzup\\\/author\\\/site-admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[#Script #Coding] SQL Server Performance Essentials &ndash; Full Course - WHUZZUP!","description":"In this course, Essentials of SQL Server Performance For Every Developer, you will see how to diagnose what is happening with a slow running","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/","og_locale":"en_US","og_type":"article","og_title":"[#Script #Coding] SQL Server Performance Essentials &ndash; Full Course - WHUZZUP!","og_description":"In this course, Essentials of SQL Server Performance For Every Developer, you will see how to diagnose what is happening with a slow running","og_url":"https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/","og_site_name":"WHUZZUP!","article_publisher":"https:\/\/www.facebook.com\/EricBrooksDotComWeb\/","article_author":"EricBrooksDotComWeb","article_published_time":"2022-12-21T05:00:01+00:00","article_modified_time":"2022-12-22T03:18:49+00:00","og_image":[{"url":"https:\/\/i1.ytimg.com\/vi\/HvxmF0FUwrM\/hqdefault.jpg","type":"","width":"","height":""}],"author":"Eric Brooks","twitter_card":"summary_large_image","twitter_creator":"@EricBrooksCom","twitter_site":"@EricBrooksCom","twitter_misc":{"Written by":"Eric Brooks","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/#article","isPartOf":{"@id":"https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/"},"author":{"name":"Eric Brooks","@id":"https:\/\/ericbrooks.com\/whuzzup\/#\/schema\/person\/3b162468e1f9814f6e9f61460db00a3a"},"headline":"[#Script #Coding] SQL Server Performance Essentials &ndash; Full Course","datePublished":"2022-12-21T05:00:01+00:00","dateModified":"2022-12-22T03:18:49+00:00","mainEntityOfPage":{"@id":"https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/"},"wordCount":390,"commentCount":0,"publisher":{"@id":"https:\/\/ericbrooks.com\/whuzzup\/#organization"},"image":{"@id":"https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/#primaryimage"},"thumbnailUrl":"https:\/\/i1.ytimg.com\/vi\/HvxmF0FUwrM\/hqdefault.jpg","keywords":["Developer","freecodecamp","Rajan Arora","Server","SQL"],"articleSection":["Scripting and Coding","Video Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/","url":"https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/","name":"[#Script #Coding] SQL Server Performance Essentials &ndash; Full Course - WHUZZUP!","isPartOf":{"@id":"https:\/\/ericbrooks.com\/whuzzup\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/#primaryimage"},"image":{"@id":"https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/#primaryimage"},"thumbnailUrl":"https:\/\/i1.ytimg.com\/vi\/HvxmF0FUwrM\/hqdefault.jpg","datePublished":"2022-12-21T05:00:01+00:00","dateModified":"2022-12-22T03:18:49+00:00","description":"In this course, Essentials of SQL Server Performance For Every Developer, you will see how to diagnose what is happening with a slow running","breadcrumb":{"@id":"https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/#primaryimage","url":"https:\/\/i1.ytimg.com\/vi\/HvxmF0FUwrM\/hqdefault.jpg","contentUrl":"https:\/\/i1.ytimg.com\/vi\/HvxmF0FUwrM\/hqdefault.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/ericbrooks.com\/whuzzup\/script-coding-sql-server-performance-essentials-ndash-full-course\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ericbrooks.com\/whuzzup\/"},{"@type":"ListItem","position":2,"name":"[#Script #Coding] SQL Server Performance Essentials &ndash; Full Course"}]},{"@type":"WebSite","@id":"https:\/\/ericbrooks.com\/whuzzup\/#website","url":"https:\/\/ericbrooks.com\/whuzzup\/","name":"WHUZZUP!","description":"What&#039;s new at EricBrooks.Com plus news and gossip all over CyberTown","publisher":{"@id":"https:\/\/ericbrooks.com\/whuzzup\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ericbrooks.com\/whuzzup\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ericbrooks.com\/whuzzup\/#organization","name":"WHUZZUP!","url":"https:\/\/ericbrooks.com\/whuzzup\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ericbrooks.com\/whuzzup\/#\/schema\/logo\/image\/","url":"https:\/\/ericbrooks.com\/images\/posts\/cropped-favicon_64-1.png","contentUrl":"https:\/\/ericbrooks.com\/images\/posts\/cropped-favicon_64-1.png","width":512,"height":512,"caption":"WHUZZUP!"},"image":{"@id":"https:\/\/ericbrooks.com\/whuzzup\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/EricBrooksDotComWeb\/","https:\/\/x.com\/EricBrooksCom","https:\/\/www.instagram.com\/ericbrooksdotcom\/","https:\/\/www.linkedin.com\/in\/ericbrooksdotcom","https:\/\/myspace.com\/ericbrooksdotcom","https:\/\/www.pinterest.com\/ericbrookscom\/","https:\/\/www.youtube.com\/user\/ericbrooksdotcom"]},{"@type":"Person","@id":"https:\/\/ericbrooks.com\/whuzzup\/#\/schema\/person\/3b162468e1f9814f6e9f61460db00a3a","name":"Eric Brooks","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/62114f8baf9a3737e7686125b69907010ad6aff5dfc07c12707e8a18bb49bc34?s=96&d=blank&r=x","url":"https:\/\/secure.gravatar.com\/avatar\/62114f8baf9a3737e7686125b69907010ad6aff5dfc07c12707e8a18bb49bc34?s=96&d=blank&r=x","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/62114f8baf9a3737e7686125b69907010ad6aff5dfc07c12707e8a18bb49bc34?s=96&d=blank&r=x","caption":"Eric Brooks"},"description":"Web &amp; Graphic Designer, Blogger, Musician, Evil Clown. I also code websites and promote people for a living. Still kind of a jerk, though. Approach with food.","sameAs":["https:\/\/ericbrooks.com","EricBrooksDotComWeb","ericbrooksdotcom","ericbrookscom\/","https:\/\/x.com\/EricBrooksCom"],"url":"https:\/\/ericbrooks.com\/whuzzup\/author\/site-admin\/"}]}},"_links":{"self":[{"href":"https:\/\/ericbrooks.com\/whuzzup\/wp-json\/wp\/v2\/posts\/36773","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ericbrooks.com\/whuzzup\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ericbrooks.com\/whuzzup\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ericbrooks.com\/whuzzup\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ericbrooks.com\/whuzzup\/wp-json\/wp\/v2\/comments?post=36773"}],"version-history":[{"count":1,"href":"https:\/\/ericbrooks.com\/whuzzup\/wp-json\/wp\/v2\/posts\/36773\/revisions"}],"predecessor-version":[{"id":36785,"href":"https:\/\/ericbrooks.com\/whuzzup\/wp-json\/wp\/v2\/posts\/36773\/revisions\/36785"}],"wp:attachment":[{"href":"https:\/\/ericbrooks.com\/whuzzup\/wp-json\/wp\/v2\/media?parent=36773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ericbrooks.com\/whuzzup\/wp-json\/wp\/v2\/categories?post=36773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ericbrooks.com\/whuzzup\/wp-json\/wp\/v2\/tags?post=36773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}