...

HI Nakul, Really fantastic stuff. Thanks for sharing...

Extending the Windows user experience of file searches to SQL server is a bit of a challenge because the asterisk [*] is a wild-card character in Windows whereas SQL Server uses percentage [%]. The percentage [%] is valid in a file name which adds to th...

...

@Riks, There are 2 things to observe. 1. If we use COUNT(CASE WHEN gender='M' THEN 1 ELSE 0 END) , RESULT= COUNT(CONDITIONAL PART + ELSE PART) that means like COUNT(*) 2. If we use SUM(CASE WHEN gender='M' THEN 1 ELSE 0 END) , RESULT= COUNT(CO...

HI Madhivanan, Thanks for original Post Thanks....

...

In this post, we take a look at the Dynamic Management Vies, functions and Catalog Views related to AlwaysON! - the High Availability & Disaster Recovery [HADR] enhancements introduced in SQL Server 2012....

HI Madhivanan, I think its following the UNION ALL principle. Please correct me if i am wrong. Thanks...

...