JLION.COM - SQL Server

Articles

SQL Server

5/4/2009	SQL for cleaning data It's spring, and that means spring-data-cleaning time. Here are some functions that help break text in a last-name-first field into separate last name, first name and middle name components.
2/29/2008	Extended WHOIS for SQL Server Extended WHOIS procedure that includes buffer contents. Works with all versions of SQL Server 2000 and newer.
9/22/2007	SQLAutoDoc database & monitoring utility The second version of the SQLAutoDoc database & monitoring utility has been released. This new release includes much new functionality including versioning, compare, and status monitoring for size, blocking, connections and waitstates.
8/15/2007	Working with Time Frames in T-SQL This is an article I wrote for SQLServerCentral about querying data for time frames. IE: Finding activity that took place during a specific minute/hour/day when most activity is several minutes/hours/days in length.
1/15/2007	SQL Server Date Handling A general overview of date handling with SQL Server
1/15/2007	Adding a foreign key with Transact SQL Examples of using Transact SQL to add foreign key and primary key constraints
1/14/2007	Creating Foreign Keys for SQL Server using Transact SQL A quick guide to using DDL to create foreign keys.
12/9/2006	Geolocation Strategies Some thoughts on how best to measure the distance between two addresses + a haversine function for sql server.
11/7/2005	SQL Snippets Small SQL Snippets for various tasks.
10/11/2005	How to set up SQL Server 2000's SQL Mail to use SMTP/POP instead of Exchange Server The SQL Server documentation isn't clear on how to configure SQL Server 2000 to support SQL Mail and the xp_sendmail command. This guide fills in some of the gaps in the documentation.