Excellant coverage !!!...

...

...

As we know, in SQL Server we can almost use SET-BASED approach to implement any kind of business logic. Rarely CURSOR is used in some cases. Now the question is "When did you use CURSOR to get better performance than SET-BASED approach?"...

...

POWER is one of the mathematical functions used in SQL Server which returns the value of the expression to a specific power. But it rounds the values after 16 digits if the result is more than 16 digits. Consider the following exampledeclare @value deci...

A myth around IDENTITY columns is that values cannot be inserted explicitly into IDENTITY columns. Not only can IDENTITY columns accept explicit inserts via the IDENTITY_INSERT option, this is one of the most used methods when working with replication a...

Good series of posts. Keep it up Nakul...

...

Thanks Jeff Moden for your valuable feedback. Whenever there is a post about tally number table, I always refer your article....