Querying an Oracle linked server fails
The other day, I needed to pull some data from an Oracle server on our network. The oracle server was […]
Programming, SQL Blogs
SQL Blogs
SQL Blogs
Great Circles in SQL Server 2005 and SQL Server 2000
Recently, I had a request to calculate the distance between 2 GPS coordinates. Now, the system I am working with
SQL Blogs
Automatic Index Rebuilding
While working on a large project, I found that the queries were running slower and slower as the days went
Kill all Connections to a Database in SQL Server
One of the databases I work with runs a ton of updates overnight and in the early morning. Now, from