Viewing 15 posts - 1,651 through 1,665 (of 59,066 total)
This was the error message
Msg 8144, Level 16, State 3, Line 12 Procedure or function string_split has too many arguments specified.
Completion time: 2023-03-24T13:47:00.0877172+05:30
That probably means that you're not actually...
March 24, 2023 at 5:13 pm
What I "love" about these scrum sprint agile and the newer cicd developments is that most managers think it will speed up their sloppy work.
They still don't have a...
March 24, 2023 at 12:55 am
March 23, 2023 at 10:48 pm
Also, why not just use
ORDER BY BusinessEntityID, OrderDate?
It might perform better.
+1000
March 22, 2023 at 4:16 pm
I'm the same way. I've been at the same place coming up on 12 years. Great people, interesting work, good pay and bennies, a commute that I could make on...
March 21, 2023 at 9:00 pm
I feel your pain. This is micromanagement at its worst. Personally, I won't row to the sound of a beating drum, the cadence of which has been created by people...
March 21, 2023 at 4:30 pm
I have a script that was running fine but today it is taking way too long. I looked at the script and I see these errors:
"cannot specify included columns...
March 21, 2023 at 3:42 pm
where Date From >= '2020-04-01' and Date To <= '2020-04-28'
There is no data in your sample that meets that requirement.
In
2 ----- 2020-04-01 -----...
March 21, 2023 at 3:29 pm
Ok... first off, your column naming structure flat out isn't going to work. It's a worst practice to include spaces in any object names including column names.
Second, if you want...
March 21, 2023 at 3:28 pm
Heh... I'm thinking about Left_Shift() and Right_Shift() (I always knew them as Shift-Left and Shift_right in the old days). I can see that giving new meaning to the term RBAR. ...
March 21, 2023 at 1:45 pm
In most cases (there are exceptions to everything) the following settings absolutely suck on any server...
cost threshold for parallelism 5 -- General advice here is to start at 50 and...
March 20, 2023 at 4:56 pm
Start with the "Key Configuration Options" in the following article. Every single thing there can make a pretty good difference.
https://glennsqlperformance.com/2020/08/20/preventing-sql-server-upgrade-performance-issues/
March 19, 2023 at 9:29 pm
Jeff - The trigger did capture the change of a non-null value to null when I removed the date form an item and dtInactive was set to NULL.
Sorry. I...
March 17, 2023 at 7:11 pm
That's a great answer, Gulshan.
March 17, 2023 at 5:53 pm
Viewing 15 posts - 1,651 through 1,665 (of 59,066 total)