Learned new function for count while going through the channel 9 video for salva. where for a very big table count it gave an error :
Count_Big() – BOL:
Returns the number of items in a group. COUNT_BIG works like the COUNT function. The only difference between the two functions is their return values. COUNT_BIG always returns a bigintdata type value. COUNT always returns an int data type value
https://docs.microsoft.com/en-us/sql/t-sql/functions/count-big-transact-sql