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)
9,104 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,962 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)
10,941 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,902 reads
Blogs
A New Word: Immerensis
By Steve Jones
immerensis – n. the maddening inability to understand the reasons why someone loves you...
Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault
In this post, I will guide you on how to deploy a dockerized simple...
SQL Server Wait Stats
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
Forums
mysql query timeout upped but job still fails about same number of minutes in
hi, i changed my mysql based linked server's timeout to N'600' instead of N'0'...
Somebody realized to configure Cluster-Aware updating on VMWare nodes
Creating an Windows Server Fail-over Clusters with two SQL server 2022 and a File...
is it cache or something else
hi a few days ago i narrowed down the cause of a new problem...
Question of the Day
SQL Server Collations
At what levels can we set the collation in SQL Server 2022?
See possible answers