SQL Server Blog

Home/SQL Server Blog/

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

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 [...]

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

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 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 [...]

SQL Server Plan Cache Bloating

In this post we will see how & why Plan Cache bloating happens – just a few examples. We are going to use AdventureWorks2016 database for this demo. Let’s first free the Plan Cache: DBCC FREEPROCCACHE Next, let’s fire a simple select statement, with one predicate. select * FROM Person.Person where LastName = ‘duffy’ We [...]

Master Class: SQL Performance Tuning

Do you wish to continue getting SQL content from us? If yes, please subscribe to our new list. Hi There, Here are the headlines for today's bulletin from SQLMaestros. #1 Performance Tuning Master Classes have been scheduled for 21/22 July & Nov/Dec time frame. We have the fast-track version (8 hours) in July & the [...]