If this is something you are still working on, there is a fairly extensive discussion of the techniques for defining the square around the circle on this thread:

Great Circle Distance...

paul.knibbs (5/19/2010)

---

Another good reason for not using the One True Lookup Table is the lack of flexibility. Your requirements right now mean that all those different lookup types have the...

meichner (5/18/2010)

...I have limited experience with this, so I guess I also have limited vision as to the problems. I am not sure that I understand the 'two column'...

I have never understood the attraction of having one table with many different types of entities.

As mentioned, it is a violation of rules of normalization, so that is a sign...

Just let "Bob" have unlimited access, then when the rest of the users complain about the slow system, make a point of telling them it's being slowed down by one...

djackson 22568 (5/17/2010)

---

This issue is not limited to database advice, programming advice, or even computers in general. I volunteer on a soccer board, handling registration. We receive complaints...

If the full backup is too large to get over the network, send that overnight in a package on tape or USB disk, and then send the transaction log backups...

ray 78019 (5/17/2010)

---

I have a function that is supposed to get the next maximum value (plus 1) from a table. Here is the T-SQL:

ALTER FUNCTION [dbo].[udfDtsGetNewTraceID]

(

)

RETURNS INT

AS

BEGIN

...

Lynn Pettis (5/10/2010)

...Who else is going to listen to the problems we have encountered and how we solved them, or what accomplishments we may have achieved at work? My...

You might consider running your application on SQL Server 2008 with the database compatibility level set to 80 (SQL 2000).

That should prevent problems with code that is not compatible with...

If you are loading the table from an outside source across the network, it would probably be faster to do it this way:

1. Truncate the table and drop all non-clustered...

You might want to consider going with Workgroup of Standard Edition.

The limitation of a 4GB database is fairly easy to hit. The lack of a SQL Server Agent in...

This is fairly simple:

select

*,

MonthNumber = month([month]+' 1 2010')

from

( --test data

select [month] = 'January' union all

select [month] = 'April'...

Run this script to see how much free space you have in each database file, and how much space each table is using:

Script to analyze table space usage

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762

Run this script...

The DATETIME datatype only has 3 digits, so you cannot get 6 digits.