Forum Replies Created
Viewing 15 posts - 16 through 30 (of 2,451 total)
-
Reply To: Execution plan flips from "good" to "bad" at a certain threshold
A couple things to consider. First, In SSMS 2019 the actual execution plan will show you how much time each portion of the query took. You don't need that here...
-
Reply To: can't get Numbers from Name to prevent conversion failed ?
Grab a copy of PatReplace8K and it should be easy to strip out what you need.
SELECT
pa.*,
Clean1 = CAST(ISNULL(pr.newString,0) AS FLOAT),
... -
Reply To: Longest Common Substring in an ITVF
What you posted is similar to my first version of this except that I use my ngrams function to generate the tally table. Here's a simplified...
-
Reply To: string compare again .. :)
Jeff Moden wrote:Agreed. I said similar in this post from above...
I missed this.
The difference is that I did the split using an indexed view. This way the split only happens once,...
-
Reply To: string compare again .. :)
Just as a side note, depending on how often your columns are updated/modified, you can always split the string ahead of time using a permanent tally table like this:
-
Reply To: Longest Common Substring in an ITVF
Jeff Moden wrote:I'm not seeing any code attached to your last post. What code are you talking about being "attached"?
Grrr...
/*********************************** PART #1...
-
Reply To: Longest Common Substring in an ITVF
UPDATED 20200803 at 9:30PM
Ok, 4 1/2 years later I have a something really good to show!
This code is from one of many articles in various phases of completion which I'll...
-
Reply To: The Computing Revolution
Great article Steve. Really informative.
-
Reply To: Regex Help
I've just added CLR Regex Functions to our SQL Servers.
I'm trying to replace some of our less efficient string parsing TSQL functions with the new .Net CLR Regex Functions.
For things...
-
Reply To: Are the posted questions getting worse?
If anyone is interested in a rather interesting problem has a look at this: https://www.sqlservercentral.com/forums/topic/table-function-returns-varying-number-of-records-for-an-update-statement
I gave up.
-
Reply To: Table Function returns varying number of records for an update statement
I'm really curios to what is happening internally for the varying set of records that get updated.
This is one of the more interesting problems I've seen in a while on...
-
Reply To: Table Function returns varying number of records for an update statement
To quote Ned Flanders, "Wow! As melon scratchers go, that's a honey doodle."
I can confirm that I see the same issue and racked my brain trying to figure out how...
-
Reply To: Extract Blocks of Number
Grab a copy of NGrams8k and you can do this:
Declare @Temp Table(SomeId INT IDENTITY, [Data] VarChar(8000))
Insert @Temp ([Data])
Values('hello my name is john 07999999999 smith 07888888888 this last...
Viewing 15 posts - 16 through 30 (of 2,451 total)