May 30, 2013
March 1, 2013
I found the INFORMATION_SCHEMA.ROUTINES truncates the data.
This however does the trick
select OBJECT_NAME(id) from sys.syscomments
where [text] like ‘%YourSearchString%’
February 28, 2013
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SET STATISTICS TIME ON
October 11, 2012
Anybody that drives a motorized vehicle of ANY sort should go on a advanced training course.
I recently bought a bike (Honda VFR400 NC30) and got told about this event, that was run over 2 days. It was organized by the Wheels Motor cycle club (http://www.wheels-mcc.co.za/). It included information about first aid, traffic laws, maintenance of your bike, and most importantly helpfull advice and tips from people that have been doing this for a very long time.
It has made a tremendous impact, on my level of comfort in controlling my bike, especially in traffic.
Oh and being on the track is HIGHLY ADDICTIVE
July 23, 2012
SET PathToDBCode=”C:\f1\cc\Data Layer”
@Echo Starting Deploy at %time%
REM Setting up enviroment variables
path = %path%;%systemroot%\Microsoft.NET\Framework\v4.0.30319;”c:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin”
CALL msbuild.exe /v:q /t:Clean,Build,Publish /p:SqlPublishProfilePath=local.publish.xml %PathToDBCode%\DB\CloudCoreDB\CloudCoreDB.sln”
@Echo Starting SQL Metal at %time%
@Echo All Done
@Echo Giving permissions %time%
CALL sqlcmd.exe -S. -E -dCloudCoreDb -Q “EXEC sp_addrolemember N’db_owner’, N’diauser’”
@Echo All Done
June 26, 2012
I found this good post at this location:(http://forums.gpsreview.net/viewtopic.php?t=3632) the Author is David B. Robert
Hello everyone. I look forward to getting acquainted with this forum. This is my first post. I hope most of you will find it useful.
As a GPS owner I often like to find the coordinates of a location I’m traveling too beforehand. I’ve used Google Earth and Delorme Street Atlas USA in the Past.
Google Maps is so convenient, but unfortunately does not conveniently show the Latitude and Longitude of locations. However I’ve found this method that works real nice.
1. I open Google Maps to the vicinity of where I would like coordinates.
2. I use my right click mouse button and select “center map here” from the drop down button.
Here’s the code:
4. I click the “go to the address in the location bar” button usually to the right of the address.
5. A popup appears showing the coordinates of the center of the map like this: (43.60336, -110.7362)
6. I right click on the coordinates the copy and click either “OK” or “Cancel”
7. I then paste the coordinates into google’s “search maps” text box, remove the parenthesis and click “Search Maps”
8. A popup appears with a marker for the centered spot. The popup has the coordinates in both Decimal Degrees and Degrees, Minutes, Seconds.
9. I refine as and if necessary and I have my way point for inserting into my GPS.
I hope some of you find this useful. I know I do.
David B. Robert founder of ProximityCast.com