Calculate Distance in Miles from Latitude and Longitude
A fast and accurate way to calculate the distance in miles between two points, based on the latitudes and longitudes.
2014-09-26 (first published: 2009-01-31)
7,217 reads
Table Information View -- No Cursors!
Row counts and storage space information for all tables in the database. (SQL Server 2005).
2013-12-26 (first published: 2008-03-16)
16,113 reads
Find all objects in Server Owned by a Login
Find every object in every database owned by a particular Login.
2011-09-27 (first published: 2008-07-07)
5,835 reads
EXECute SQL Commands over entire sets of parameters!
A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.
2010-03-16 (first published: 2010-03-04)
2,858 reads
Blogs
GotoWebinar (and Teams) won’t screen share after macOS update to Catalina (10.15)
By HamishWatson
This blog post is about the situation where after upgrading to the latest macOS...
Improving TweetDeck with Better TweetDeck
By John
If you are at involved with the #sqlfamily, you are bound to hear about...
Interview with Bob Ward
By damianwidera
This is the eight interview we have done. This time our guest is the...
Forums
water pipes recycler premium components
this lookah glass[/url] underside can be an inverted tapering cone with a small...
Remove the middle of a string between wildcards
I have a field called 'jsonpayload' in a table called 'auditlog' that is populated...
Is SSIS really that bad?
Today we had our weekly team meeting. Part of my team is working on...
Ask SSC