If you ever wonder which one is really faster in Distinct vs Group By Performance Test then I will show some facts in this post so you can write your query accordingly. To test distinct vs group by performance in SQL Query …
In this post I will show you how to overwrite sql server backup file rather than append (default action is append to backup media set) If you try below t-sql command to take full sql server database backup then you …
How to overwrite SQL Server Backup rather than Append Mediaset Read more »
Many times we have to write recursive parent child query (Multiple levels of Parent-Child Links) in SQL Server. There are multiple approaches to achieve this Using Hierarchy ID builtin CLR datatype in SQL Server 2008 or higher (not ion sql server …
SQL Server parent child query example using recursive CTE (Common Table Expression) Read more »
How many time you had to t sql date format date specific way such as yyyymmdd ?? Many people don’t know hidden feature of builtin T-SQL CONVERT function . This function can not only convert data types but also change format of dates/numbers. …
SQL Date format using T-SQL CONVERT function (More than 40 formats) Read more »