Viewing 15 posts - 53,071 through 53,085 (of 59,064 total)
I guess we also need to know the number of rows in the two tables, please.
January 5, 2008 at 8:20 pm
Heh... use the GRID mode instead of the TEXT mode...
January 5, 2008 at 5:35 pm
Topher, please post the command you want to execute on all of the databases and what you'd like the output to look like.
January 5, 2008 at 5:26 pm
In SQL Server 2000, there is no "Modified Date" on a stored procedure. So I always drop the procedure and recreate it so the Create Date shows the latest...
January 5, 2008 at 4:49 pm
Heh... C'mon Phil... 😛 this is a 7/2k Forum... there is no VARCHAR(MAX).
January 5, 2008 at 4:35 pm
Thanks Phil...
Folks, I don't understand why anyone needs VBS for this... why not just do it directly in T-SQL? Heh... everyone gripes about me coming down hard on cursors,...
January 5, 2008 at 2:50 pm
I'm thinking this is for an SQL class... with that in mind, now that I've given you the distance function, you must try first... also, see the following... it will...
January 5, 2008 at 1:07 pm
Ananth,
Books Online (comes free with SQL Server) also has a wealth of knowledge on how indexes work and how to build them...
January 5, 2008 at 9:42 am
Heh... ten to one says monthly, weekly, or even daily transaction databases... folks do that a lot especially in the telephone business (Call detail records saved in monthly databases based...
January 5, 2008 at 9:34 am
It would appear from things like "[Expr1002]=Convert([pt3].[STORE_KEY]) " found in the execution plan that 1 or 2 things may really be causing the performance problems...
The first thing is that that...
January 5, 2008 at 9:27 am
For the distance formula, please see your other post at the following URL...
http://www.sqlservercentral.com/Forums/Topic439224-338-1.aspx
... that should get you started...
January 5, 2008 at 9:10 am
Phil,
Nothing attached and no code visible... dunno if that was your intent, or not...
January 5, 2008 at 9:07 am
The only problem I see in such a naming convention is if you have a usefull function, proc, table, or view that is used in one schema that you'd like...
January 5, 2008 at 9:04 am
p.s. IF, by chance, you are using the V&H coordinates (as Telcordia calls them) from the "Donald Projection" that is used so often for calculating distance for telephony, airlines,...
January 5, 2008 at 8:54 am
SQRT and SQUARE are standard mathematical functions in pretty much every make and flavor of SQL including SQL Server.
Your values of the coordinates of x1, x2, y1, and y2 can...
January 5, 2008 at 8:43 am
Viewing 15 posts - 53,071 through 53,085 (of 59,064 total)