In this video, we are going to learn; How we can Generate rows dynamically for each record of a table in set based approach, and How to do calculations on each row of a table generated dynamically You can download the script used in this example from below the video.
Unfolding | Set Based Approach | Generate Rows Dynamically – Episode 6 Read More »
In this video, we are going to understand Tally table which is very useful in writing set based SQL queries. You can download the script which can be used to create the Tally table from below the video.
Unfolding | Set Based Approach | Tally Table – Episode 5 Read More »
In this video, we are going to understand how join works internally. If you have a good understanding of joins and how it works, you can skip this video and move to the next video in this series. If not, lets start understanding the joins. You can download the script used in this example from below the video. Here
Unfolding | Set Based Approach | How join works internally – Episode 4 Read More »
In this video, we are going to understand the query execution architecture which helps us to understand the importance of set based approach. When a T-SQL statement gets submitted to SQL server, it goes through multiple steps before we get the final output. Lets have a look on SQL Server query execution architecture.
Unfolding | Set Based Approach | SQL Server Query execution architecture – Episode 3 Read More »
