With help of below query we can quickly find the node on which sql is currently running. This is useful in clustered environments.
Select serverproperty('ComputerNamePhysicalNetBIOS')
Published under: · · · ·