Historically the use of User Defined Functions aka UDF has represented a great option to encapsulate logic into Database reusable…
This is the second article of a series dedicated to implementing Recursive Common Table Expression in different kind of scenarios,…
I remember the first time that I discovered the amazing feature called Common Table Expression (CTE), it was during my…
I have to confess; I have had traumatic experiences with variant data type in my beginning as a software developer,…
There are some special scenarios where we require to generate a customized workload in our SQL Server instance, these could…