Viewing 15 posts - 5,131 through 5,145 (of 59,068 total)
Hi Everyone,
I am trying to apply a Multi table function that uses a recursive CTE. When I apply it I get the error:
The statement terminated. The maximum recursion 100...
June 10, 2021 at 2:50 pm
I know it doesn't contribute to the conversation at hand but it's just fascinating to me that this type of thing is still an issue since the release in 2005...
June 10, 2021 at 1:27 pm
So your saying that the following code that you posted took over 5 hours?
SELECT sm.Object_ID, Definition = ls.LongString FROM sys.SQL_Modules sm CROSS APPLY dbo.ShowLongString(sm.Definition) ls
I just ran that...
June 10, 2021 at 1:18 pm
Interesting. Thanks for the tips, Jeffrey.
June 10, 2021 at 3:46 am
I wonder - what happens if you run DBCC UPDATEUSAGE on that cloned database?
I believe the OP said they tried that with no success.
June 9, 2021 at 4:20 pm
People forget that DevOps is about building a culture of collaboration between people with different disciplines. It is not a bunch of technologies, buzzword bingo or fancy job titles.
Absolutely...
June 9, 2021 at 4:19 am
So your saying that the following code that you posted took over 5 hours?
SELECT sm.Object_ID, Definition = ls.LongString
FROM sys.SQL_Modules sm
CROSS APPLY dbo.ShowLongString(sm.Definition) ls
I just ran that code on my prod...
June 9, 2021 at 4:13 am
Tried TRUNCATE - no errors. Tried DELETE - 0 rows affected.
But I probably found the reason, this is likely to be a cloned database, that was created with DBCC...
June 8, 2021 at 10:49 pm
I tried, but we are still having records that are unmatched.
Then you have actually having records that don't match because the function is not capable of creating different outputs...
June 8, 2021 at 6:36 pm
Another way... the formula in the CROSS APPLY converts the substring to a DATETIME2 just in case you want to see how to do that. The WHERE clause ensures that...
June 8, 2021 at 4:05 pm
This seems to be really destructive. Are you just trying to do "Data Masking"?
If you really do want what you've stated, then it's real simple (using the test table...
June 8, 2021 at 1:30 pm
I don't know of any such change. I'm thinking that there would be a million person march on Redmond if there were. Have you checked the raw data to see...
June 8, 2021 at 1:03 pm
Considering that my last name contains only 5 letters and you couldn't even spell that right, I suspect a PICNIC problem on your part. The code runs nasty fast in...
June 8, 2021 at 12:58 pm
Hang in there. I made some good progress (fully testing along the way) but I had another late work night and it's time for bed (01:49 AM). I'll work on...
June 8, 2021 at 5:50 am
We're just guessing here... post the actual code for get_OrderVerified
June 7, 2021 at 5:19 pm
Viewing 15 posts - 5,131 through 5,145 (of 59,068 total)