THE VIDEO THE SYNOPSIS In this video, I show you various techniques you can use to make window functions faster, including proper indexing and usage of batch mode. I also demonstrate the performance difference between RANGE and ROWS. LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf of Catallaxy Services, LLC, my consulting company…| 36 Chambers – The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video, I take you through some of the limitations of window functions in SQL Server, including the lack of intervals and oddities around the APPLY operator. LINKS AND…| 36 Chambers - The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video, I take you through a variety of use cases for window functions, showing how you can solve common (and sometimes uncommon) business problems efficiently and effectively. LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on…| 36 Chambers – The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video, I continue a dive into each category of window function, quickly reviewing the four categories of window function (plus ordered set functions). Then, I cover o…| 36 Chambers - The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video, I walk through four categories of window function, plus a somewhat-related type of function in SQL Server. From there, I demonstrate how aggregate window functions and ranking window functions work. LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where…| 36 Chambers – The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video (part 1 of a new series), I explain what a window function is, as well as the components of window functions. LINKS AND ADDITIONAL INFORMATION All of these vide…| 36 Chambers - The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video, I show how we can use the APPLY operator to reshape datasets, allowing us to unpivot tables and also calculate the greatest and least values for a row. LINKS A…| 36 Chambers - The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video, I show how we can use the APPLY operator to remove redundancy in the SELECT clause and simplify complex calculations, all with zero performance impact. LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems…| 36 Chambers – The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video, I show how we can use the APPLY operator to find records associated with a “parent” table. We look at getting the latest record, as well as any arb…| 36 Chambers - The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video, I show how we can use the APPLY operator to operate on ad hoc functions. That leads to a powerful use case: pre-aggregating data. LINKS AND ADDITIONAL INFORMAT…| 36 Chambers - The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video, I show how we can integrate an Azure OpenAI GPT-4 model into our Streamlit dashboard. Along the way, I also show off how easy it is to create multiple pages an…| 36 Chambers - The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video, I extend the Streamlit app that we’ve been working on even more. We’ll convert a set of drop-down lists into a form, change the behavior of these d…| 36 Chambers - The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video, I extend a Streamlit app that I created in the prior video. This extension will include retrieving data from SQL Server, caching function results, operating a …| 36 Chambers - The Legendary Journeys: Execution to the max!
