SQLSERVER 2017 introduced a new feature called TRANSLATE which works similar to REPLACE function,but very flexible and powerfull. [Read More]

Today i learnt a new way to calculate Moving averages and it is quite simple with Window Functions Frame clauses.Thanks to Itzik Ben-Gan. [Read More]

I was trying to setup windbg to explore more about SQLServer internals.My search lead me to this book ,The Guru’s Guide to SQL Server Architecture and Internals…I was amazed about the quality of the content and the way it was presented.. [Read More]

I get this question many times,so thought of creating a post about how i learned .. [Read More]

This is an answer for an interview i appeared.The question was to optimize below query..Unfortunately their site didn’t allow special characters ,so i had to post the answer on my blog and provided link to them.I felt happy about this answer,so it thought of leaving it like this.. [Read More]