SQL Server Blog

Home/SQL Server Blog/

SQL Server Query Tuning – What is the execution time?

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

Query Tuning Training on Thursday (Jan 27)

Hi There, Jan 27, Thursday, is here. Query Tuning training. Do not miss. Register Here. #1 Take a glance at SQLMaestros Corporate Services. Learn More. #2 New SQL Videos: SQL Server Order By clause - A tricky behavior Estimates vs Actual Runtime Statistics Watch on SQLMaestros home page or directly jump to our video lobby. [...]

SQL Server Order By Clause – Tricky Behavior

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

Query Tuning – Estimates vs Actual Runtime Statistics

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

Query Tuning Training Next Week – Sign Up Now

Hi There, Loads of SQL content for you. #1 Ask your team members to join the Query Tuning training next week. Learn More. It costs nothing. Forward this email to your team members. #2 New SQL Videos: Index Usage Stats DMV gets reset SOS_Scheduler_Yield Wait Type Estimates vs Actual Runtime Statistics Watch on SQLMaestros home [...]

Get the Actual Execution Plan from the Plan Cache

Many SQL folks believe that the execution plan they see in the plan cache is an Actual Execution Plan. Unfortunately, it is an Estimated Execution Plan. An Estimated Execution Plan does not have actual runtime statistics that may be helpful in query tuning. Actual Execution Plan has the runtime stats that you really need. Well, [...]

SPID blocking itself in SQL Server

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

Extract Wait Type information from the Execution Plan

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

Deadlock within a single table

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

SQL Server Deadlock due to Bookmark Lookup

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

SQL Server Sort Behavior – Basic yet Tricky

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

SOS_SCHEDULER_YIELD Wait Type does not show up in Waiting Tasks DMV

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

Index Usage Stats DMV gets reset

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

Minimize THREADPOOL Wait Type in SQL Server

A thread is the lowest unit of execution. Your SQL query, at the least, needs one thread to run. Depending on the SQL instance configurations and the eligibility of the query, SQL Server may decide to execute your query with multiple threads - this is called parallelism. If too many such workloads are parallelized and [...]

Index Seek may not always be faster

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]

Are you attending the Query Tuning training?

Hi There, SQL stuff for the week. #1 Want to get started with SQL query optimization? Join this online training course on Query Tuning. Learn More. Don't miss. It costs nothing. #2 New SQL Video: SQL Server Sort Behavior – Basic yet Tricky. More videos here. #3 Short SQL Server Notes by AB. Here. #4 [...]

New SQL Tutorials

Hi There, We took a break, and now we are back with lot of SQL content and learning opportunities. #1 New SQL Video: Retrieve the Actual Execution Plan from the Plan Cache. More videos here. #2 SQL Tip of the day. Here. #3 SQLMaestros Master Classes: New batches for SQL Server Performance Tuning – Fast [...]

SQL Performance Tuning Master Class Recordings Available

Do you wish to continue getting SQL content from us? If yes, please subscribe to our new list. Hi There, Class Recordings for SQL Server Performance Tuning Master Class are now available. Last week, the class was successfully executed. See here for some incredible feedback received. Recordings can be accessed now. Learn more. Next set [...]

SQL Performance Tuning Master Class This Week (Wednesday/Thursday)

Do you wish to continue getting SQL content from us? If yes, please subscribe to our new list. Hi There, SQLMaestros Master Class on SQL Server Performance Tuning – Fast Track (Online) is coming up this week (21/22 July). Join this demo-filled, 8-hour class (4 hours per day), where you will learn the three approaches [...]

SQL Performance Tuning Master Class Next Week

Do you wish to continue getting SQL videos from us? If yes, please subscribe to our new list. Hi There, Here are the headlines for today's bulletin from SQLMaestros. #1 SQL Server Performance Tuning – Fast Track (Online) is coming up next week (21/22 July). Review the modules, topics now. And if you find it [...]