SQL Server Education (by the geeks, for the geeks)
This video is a follow up to CXPACKET video (Part 1). You will see that SQL Server Query Execution Engine still assign max number of threads (as per the number of …
SQL Server Parallelism (Part 2 of CXPACKET) (by Amit Bansal) Read MoreIn this video, you will understand the difference between sys.dm_exec_query_stats and sys.dm_exec_procedure_stats You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation …
Query Tuning – sys.dm_exec_query_stats and sys.dm_exec_procedure_stats by Amit Bansal Read MoreIn this video, you will understand how the SQL Optimizer utilizes a multi column index (Optimizer’s Choice of Indexes) You can also visit DataPlatformGeeks (DPG) Video Library to watch more …
SQL Server Index Tuning – Multi Column Seeking by Amit Bansal Read MoreIn this video, you will understand how to setup windows debugger and get ready to debug windows with public symbols You can also visit DataPlatformGeeks (DPG) Video Library to watch …
Debugging SQL Server – Setting Up Windows Debugger by Amit Bansal Read MoreIn this video, you will understand what CXPACKET Wait Type is and how you can get rid of unwanted parallelism in SQL Server. You can also visit DataPlatformGeeks (DPG) Video …
CXPACKET Wait Type in SQL Server by Amit Bansal Read MoreIn this video, you will see how you can find the elapsed time in milliseconds since SQL Server process started. [separator top=”10″] You can also visit DataPlatformGeeks (DPG) Video Library to …
When Did SQL Server Start (Database Engine Start Time) by Amit Bansal Read MoreIn this video, you will understand the difference between Processor % Processor Time & Process % Processor Time You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and …
Processor Time (Processor vs Process) – Monitoring SQL Server CPU Usage (by Amit Bansal) Read MoreIn this video, you will learn how to create a SQL Server login. You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation …
How To Create A Login In SQL Server (by Satya Ramesh) Read MoreIn-person events & webinars of March & April 2019 have been announced. You will get to network with 100+ Data & Analytics professionals in each of the in-person events in Bengaluru, …
DataPlatformGeeks In-Person Events & Webinars – March & April, 2019 Read MoreDataPlatformGeeks is inviting session submissions for its upcoming community webinars and in-person events for the month of March & April 2019. DataPlatformGeeks is a community of Data/Analytics Professionals, focused on Microsoft …
Call For Speakers – DataPlatformGeeks Community Webinars & In-Person Events Read More