This video is hosted on SQLPASS youtube channel: Neutralize Troublesome SQL Server Indexes – Fun Stories & Demos. Let us watch it.
SQL SERVER – Map SQL Server Session ID to OS Thread ID
He wanted to track the OS Thread ID in Performance Monitor. He asked me if I know any script which can Map SQL Server Session ID to OS Thread ID.Â
SQL Puzzle – SELECT ~ 1 : Guess the Answer
Of course, I have one where you have to guess the answer for a simple select statement. Let us see if you can guess it correctly or not.
SQL SERVER – Parallelism and Threads with No Work
One of my repeat clients asked me if a query goes to parallel do they use all the threads. We can have parallelism and thread with no work.
Azure Free Courses at Pluralsight
I also work on SQL Azure, MySQL, MariaDB, PostgreSQL as well as Visualization areas. I am going to share details about Azure Free Courses at Pluralsight.
SQL Azure – Install Module Fails with Error
My client told me that they need help with an error related to Install Module on SQL Azure. Let us learn how we can fix the error.
SQL SERVER – Top 1 and Index Scan
Scans are not always bad they are there because they are needed. Let us see a very simple demonstration about Top 1 and Index Scan.