Dimensional Modelling vs One Big Table
Dimensional Modelling vs One Big Table : Which is better and why? While designing a Data Warehouse one of the …
Data Engineering
This category will contain information related to data engineering concepts with practical examples and solutions to different problems.
SQL Window Function | Advanced SQL
If you are in any data-related career, you must be very well-versed in SQL concepts. One such key concept is …
What is Parameter Sniffing in SQL Server?
Sometimes in SQL Server, there is a big performance problem like one stored procedure works well for one set of …