[dba-SQLServer] StripLeadingZeros - timing

I'm curious to hear if it makes any difference it the parsing expression is
in a function, or right in the update statement. 

Typically scalar functions used in the columns has very little overhead
(compared to table valued functions that pass the data back via tempdb)

-Paul 



-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, March 20, 2008 10:15 AM
To: 'Discussion concerning MS SQL Server'
Subject: [dba-SQLServer] StripLeadingZeros - timing

I just rebuilt the stored procedure in the database that I needed to run it
in.  That at least got my update query running.  It took 38 seconds to do
just one column, the first million records.  Only 91 million more to go.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


__________ NOD32 2963 (20080320) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com