This function counts the number of 1's in the binary representation of an integer.
2015-07-28 (first published: 2014-02-24)
695 reads
I wrote this query that helps us find executed queries with most number of execution counts. The DMV that we have used in this script is sys.dm_exec_query_stats and the function that we have used is sys.dm_exec_sql_text.
2015-03-04 (first published: 2013-09-23)
3,828 reads
A new feature in SQL Server 2012 is Sequence. A Sequence object provides functionality similar to Identity.
2012-10-22 (first published: 2012-09-11)
2,029 reads
This script checks all links on the server
2012-07-05 (first published: 2012-06-15)
926 reads
Calculates bearing and distance between 2 sets of latlon coordinates
2011-06-23 (first published: 2011-06-20)
555 reads