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 Monday, July 1, 2013 8:16 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 12:06 PM
Points: 148, Visits: 293
Sean, I hate to look stupid - but this is a quality not easy to hide ...
I was not able to use iTVF in my query ... alas ...
Post #1469081
Posted Monday, July 1, 2013 8:21 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 9:40 PM
Points: 3,545, Visits: 7,657
Please post your query and the problem you had so we can help you.


Luis C.
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1469084
Posted Monday, July 1, 2013 8:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 9:46 AM
Points: 7,224, Visits: 13,696
valeryk2000 (7/1/2013)
Sean, I hate to look stupid - but this is a quality not easy to hide ...
I was not able to use iTVF in my query ... alas ...


I'm sure we can change that...


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1469085
Posted Monday, July 1, 2013 8:32 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 12:06 PM
Points: 148, Visits: 293
iTVF - 1:08
Scalar- 2:07
Long live iTVF and Sean!
Post #1469088
Posted Monday, July 1, 2013 8:35 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 2:32 PM
Points: 13,302, Visits: 12,168
valeryk2000 (7/1/2013)
iTVF - 1:08
Scalar- 2:07
Long live iTVF and Sean!


ROFL. Glad you got it working.


_______________________________________________________________

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 #1469089
Posted Monday, July 1, 2013 8:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 9:46 AM
Points: 7,224, Visits: 13,696
Sean Lange (7/1/2013)
valeryk2000 (7/1/2013)
iTVF - 1:08
Scalar- 2:07
Long live iTVF and Sean!


ROFL. Glad you got it working.


valeryk2000 (7/1/2013)
iTVF - 1:08
Scalar- 2:07
Long live iTVF and Sean!


Limping!


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1469091
Posted Monday, July 1, 2013 10:04 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 2:32 PM
Points: 13,302, Visits: 12,168
ChrisM@Work (7/1/2013)
Sean Lange (7/1/2013)
valeryk2000 (7/1/2013)
iTVF - 1:08
Scalar- 2:07
Long live iTVF and Sean!


ROFL. Glad you got it working.


valeryk2000 (7/1/2013)
iTVF - 1:08
Scalar- 2:07
Long live iTVF and Sean!


Limping!


True dat!!!

The point we are making here is that 1:08 seems pretty slow for whatever you are doing unless the row count is in the millions.


_______________________________________________________________

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 #1469139
Posted Monday, July 1, 2013 12:41 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 12:06 PM
Points: 148, Visits: 293
This table has about 9,000,000 recs.
However, when I added clustered index the time dropped to 0:32
Is it still limping?
Post #1469194
Posted Monday, July 1, 2013 12:47 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 2:32 PM
Points: 13,302, Visits: 12,168
valeryk2000 (7/1/2013)
This table has about 9,000,000 recs.
However, when I added clustered index the time dropped to 0:32
Is it still limping?


Depending on what your actual query looks like that doesn't sound horrible to select 9 million rows.


_______________________________________________________________

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 #1469195
Posted Monday, July 1, 2013 12:50 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 12:06 PM
Points: 148, Visits: 293
Take me right: the result is 15,547 rows from 9 mln rows
Post #1469197
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse