A junior developer came to me recently and asked me a SQL transformation question. He gave me an example of a SQL statement similar to this one:
select * from TableA A where A.KeyCol/10 = 12345
The p...
I am used to exploring what is available in the technology of love – SQL Server. As I was exploring into one of the simplest set of DMVs which have been available for ages. There are several ways to g...
