ViewTube

Get a Free System Design PDF with 158 pages by subscribing to our weekly newsletter: https://bytebytego.ck.page/subscribe ...

This SQL pagination clause can slow down your entire database. For large datasets, try using a relative cursor instead of using ...

In this video, we look at some simple ways to speed up your slow running SQL queries and avoid the daunting, heavy diagnostics ...

Get the AI prompt from this video: https://databasestar.mykajabi.com/lpkj-ai-sqlserver/?video=Ylh-KdYPPnE Write faster SQL ...

Want to understand what each of the steps in the Execution Plan is doing? Get my Oracle Execution Plan Guide here: ...

9 tips on SQL Server Query performance that anyone can apply right now to make your queries and your database go faster!

In order to tune SQL, you need to know what the slow statement is. But often you're just told that "the database" is slow! To find the ...

Get the scripts in the free course: https://littlekendra.com/course/tuning-a-stored-procedure-sqlchallenge-1-hour-10-minutes/

I nearly always use execution plans as the starting point for SQL query performance troubleshooting. In this multi-part series, ...

In this video, I share a practical approach to troubleshooting and reproducing code found in QueryStore or the plan cache.

Get the SQL Performance Checklist: https://databasestar.mykajabi.com/lpkj-performance-checklist/?video=kDyhijBjXTU Write ...

In this video, I share a humorous and somewhat unconventional query tuning trick that I had to use while working on a client's ...

Learn about best practices for using indexes in SQL, and how they can be used to speed up your queries, make your database ...

Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?video=TcwIkEqx8yA Learn how to ...

Get the scripts in the free course: https://littlekendra.com/course/tuning-a-stored-procedure-sqlchallenge-1-hour-10-minutes/

Investigate a slow query in a Power BI report using DAX Studio, looking at the query plan and the server timings. How to learn ...

An execution plan is one of the core tools for analyzing SQL performance. But how do you get one? And how do you make sense ...

Ready to become a certified Architect on Cloud Pak for Data? Register now and use code IBMTechYT20 for 20% off of your exam ...

Get the source code for this video for FREE → https://the-dotnet-weekly.ck.page/indexing Want to master Clean Architecture?

Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?video=ph5X1yCK_kg Write faster ...

How many times have you written a program, ETL, analysis job, etc… that seemed like it would never finish running? In this video I ...

Want to write SQL that looks like it was written by a senior developer? In this video, I'll show you 7 simple tricks that will instantly ...

In this video, we'll cover SQL and Stored Procedures in EF Core with ASP.NET Core — from FromSqlRaw, ExecuteSqlRaw, and ...

This video shows how to use the SSMS to view query execution plans and analyze the cost of the query.

If your SQL query or stored procedure suddenly become slow ...like it was working very fast earlier or yesterday but today ...