Posted inTSQL Get Decimal Scale Based on Variable Value Posted by By Ajay Dwivedi October 9, 2016 In recent past, while designing a report mailer I faced a requirement where I had…
Posted inTSQL Query Shorcuts SQL Server SSMS – Get Max Data Length Posted by By Ajay Dwivedi September 30, 2016 There are multiple articles on internet regarding Query Shortcuts in SQL Server Management Studio. So I…
Posted inPerformance Tuning TSQL Relationship data in Easy Way Posted by By Ajay Dwivedi September 27, 2016 Recently I worked on one optimisation job. It was procedure that processed multi-relationship data provided…