|
|
|
|
-
Bala Krishna Commented 1 Months ago through Blogs
HI Nakul,
Really fantastic stuff.
Thanks for sharing...
|
-
Bala Krishna Liked 1 Months ago through Blogs
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...
|
|
|
-
Bala Krishna Commented 1 Months ago through Ask
HI Shmoo,
The best way is debug your self. I mean at first take any 2 tables and join based on the condition and see the result, if expected results are coming then go and join 3rd table and see the results.Now here if u getting duplicates then probl...
|
-
Bala Krishna Commented 2 Months ago through Blogs
@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...
|
-
Bala Krishna Commented 2 Months ago through Blogs
HI Madhivanan,
Thanks for original Post
Thanks....
|
|
|
|
|
-
Bala Krishna Liked 2 Months ago through Blogs
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....
|