The below code will calculate the distance (Displacement) between two locations based on longitude and latitude. -- ============================================= -- Author: V.U.M.Sastry Sagi -- Create date: 11/30/2010 -- Description: Gets the distance between two locations -- ============================================= CREATE FUNCTION [dbo].[getDistanceBetweenLatLon] ( @lat1 DECIMAL(5, 2), @long1 DECIMAL(5, 2), @lat2 DECIMAL(5, 2), @long2 DECIMAL(5, 2) ) RETURNS NUMERIC(10,
SQL Server 2008 Extended Events are the new low level, high performance eventing system in SQL Server. They use less system resources and provide better tracking of SQL Server performance than previous methods like Perfmon and SQL Trace/Profiler events. Performance Analysis history – SQL Server 2000 & 2005 In versions prior to SQL Server 2008
Overview Services and service consumers are often on opposite sides of trust boundaries. A trust boundary is a physical or virtual boundary within which actual levels of trust can vary. A trust boundary can be an application process, a machine, or even the Internet itself. When SOAP messages flow through a trust boundary, they may