Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Extract first numeric value from a string Expand / Collapse
Author
Message
Posted Tuesday, July 2, 2013 9:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:54 AM
Points: 13,326, Visits: 12,812
valeryk2000 (7/2/2013)
Sean,
On larger chank of data your CTE-based qry runs 2.5 times faster.
I learned a lot from this discussion.
Thanks, brothers ....


Take a look at the execution plan on the larger chunk of data. You will notice that massive block for FILTER will be gone. That was consuming a huge amount of resources previously.

Glad we were able to help and thanks for letting us know.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1469631
Posted Tuesday, July 2, 2013 11:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 9, 2014 7:14 AM
Points: 148, Visits: 294
It did indeed (see attached)!
I added another join to the query - it runs now 3 sec (we started with 2 min 25 sec).
I'm excited and proud (as if I did it all by myself


  Post Attachments 
ExPlanNew.JPG (3 views, 114.15 KB)
Post #1469676
Posted Tuesday, July 2, 2013 12:09 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:54 AM
Points: 13,326, Visits: 12,812
valeryk2000 (7/2/2013)
It did indeed (see attached)!
I added another join to the query - it runs now 3 sec (we started with 2 min 25 sec).
I'm excited and proud (as if I did it all by myself


3 seconds sounds more like what I would think should be in the realm of acceptable. That is a far cry from 2:25 or even the 1:08 or whatever that you were ok with.

Glad we were able to sort this out. Come back anytime you run into issues.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1469698
Posted Tuesday, July 2, 2013 12:13 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 9, 2014 7:14 AM
Points: 148, Visits: 294
Thanks. Hope you entartained yourself as well (just a bit)
Post #1469701
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse