Scripts

Point_Bearing_Distance_To_Point 

Posted by Philip Leitch Monday, March 08, 2010 10:42:41 PM

his function converts a latitude and longatude, bearing and distance to another latitude and longitude (concatenated together).

... read more
 

Distance 

Posted by Philip Leitch Monday, March 08, 2010 10:37:37 PM

This function measures the distance between two geospatial points.

... read more
 

Earth_Radius 

Posted by Philip Leitch Monday, March 08, 2010 10:33:00 PM

This function determines the Earth's Radias at a specific latitude.

... read more
 

Compass_Direction 

Posted by Philip Leitch Monday, March 08, 2010 10:30:24 PM

 This function converts a Bearing into human readable compass text.

... read more
 

Angle_To_Bearing 

Posted by Philip Leitch Monday, March 08, 2010 10:18:51 PM

 This function converts a North and East distance to a bearing.

... read more
 

East_Distance 

Posted by Philip Leitch Monday, March 08, 2010 10:18:10 PM

 This function measures the angular distance from due East to the vector bearing.

... read more
 

North_Distance 

Posted by Philip Leitch Monday, March 08, 2010 10:16:31 PM

 This function measures the angular distance from due North to the vector bearing.

... read more
 

Working with Angles 

Posted by Philip Leitch Monday, March 08, 2010 10:07:23 PM

Using Bearing in geospatial datasets.

... read more
 

Create Insert 

Posted by Philip Leitch Tuesday, November 10, 2009 2:40:42 AM

Creates an easy "Insert" script for transfering data, dynamically constructed based on the table:

e.g. Insert into '[XYZ] Values('test', 2,2,'Value')

... read more
 

Remove Backup History 

Posted by Philip Leitch Monday, November 09, 2009 6:11:50 PM

Remove Backup History which will reduce the size of MSDB and also increase the speed of backup and restore routines.

... read more
 
Copyright 2009 Philip Leitch