Terry--

What versions and editions of SQL Server and Windows Server?

No; that's only when using AWE memory, i.e. memory greater than 4GB by using the /PAE option.

WHERE LastDate = CONVERT(char(10),GETDATE(),111)

Why use varchar(10) for dates instead of one of the temporal data types?

That's 1,048,516 Terabytes, not 1.05 Terabytes.  For each database.  Instances have no bearing on this limitation.

1,048,516TB for SQL Server 7 or SQL Server 2000, unless you're using MSDE where it's limited to 2GB.  No difference when using instances.

I can't restart a server with 4GB right now to verify this, but I believe that using just -g will be the same as not using the switch.  You will instead...

If you're using the result as a number, cast it to decimal.  If you're just displaying the result, you can use STR().

SELECT CAST(Elevation*1./Height AS dec(9,2)), STR(Elevation*1./Height,10,2)

Multiplying by 1. is the lazy...

That's normal.  SQL Server 2000 will not reserve the last 384M for its memory pool.  It still uses memory outside its pool for processes like extended stored procedures, distributed queries, and tran log...