Posts

SQL Server Performance Tuning

Hi There, We recently solved a performance issue in SQL Server. We tuned a stored procedure that was being plagued by multiple scalar function calls. And guess what - SQL Server 2019 Scalar UDF inlining feature did not work (due to some limitations). Are you facing similar performance issues in your SQL Server environment? Learn [...]

Upcoming Webinars from DataPlatformGeeks

Hi There, We at SQLMaestros support DataPlatformGeeks Community and its learning initiatives for the tech audience. They are coming up with weekly webinars. Each Thursday at 9.30 AM EDT starting from June 16, until Aug 4. Take a look and register for the ones you want to attend. Here are some popular SQL tutorials from [...]

New SQL Videos

Hi There, Here are the most popular SQL tutorials from SQLMaestros. Many of them are old but relevant with meaningful content: How to troubleshoot a slow-running query. Watch now. Query Tuning Techniques. Watch now. SQL Server Wait Types. Watch now. SQL Server Statistics. Watch now. Do not forget to subscribe to our Youtube channel. The [...]

Master Class Recordings & Lab Kit – Instant Access

Hi There, The much-awaited Master Class Recordings and the Lab Kit are now available. You can get instant access. #1 SQL Server Query Tuning & Optimization Master Class Recordings. 28 hours of content. Watch the sample content before you subscribe. And make sure to check out the module listing - it's quite exhaustive. Learn more. [...]

Master Class Recordings Released

Hi There, Trust you are doing well. You will be happy to know that Master Class recording for SQL Server Query Tuning and Optimization is now available. Total duration: 28 hours. You can subscribe and get instant access. Learn more. This 28-hour content is in-depth, comprehensive, demo-packed, and the learnings can be applied to production [...]

Query Tuning Training Next Week

Hi There, A lot of new SQL content and learning options announced. Please read carefully. #1 SQL Server Query Tuning & Optimization Master Class Recordings are now available. 28 hours of content. Learn more. #2 Query Tuning training coming up next week on April 28. No-cost. Block your seat and invite your team members too. [...]

Removing SORT Operator – SQL Server Execution Plans

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

TSQL TOP Clause Deterministic vs Non-Deterministic

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

TSQL WHERE Clause applies after ON Clause

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

Monitoring Waiting Tasks (Groups) 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 [...]

SQL Server CPU Queue

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 Index Union Operation

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 – Non Clustered Indexes have the Clustering Key

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 – What is my query doing?

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

Non Clustered Indexes May Hurt Modification Queries Performance

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

SCAN vs SEEK Performance – What to look for?

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 Performance Tuning Master Class starts Feb 14

Hi There, SQL Server Performance Tuning Master Class begins on Feb 14. This is all you need to become a performance tuning specialist. Talk to your manager and get sponsored. Learn more. #1 New SQL Video: What is Execution Time? Yeah, this is a bit tricky. Watch on SQLMaestros home page or directly jump to [...]

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