Viewing 15 posts - 796 through 810 (of 59,066 total)
Well you can test that too.
My point is... the OP hasn't identified the scenario accurately enough to even try to determine which kind of...
January 22, 2024 at 4:57 am
You missed my point... and that's actually OK. I wasn't suggesting one of the other... I was pointing out that a whole lot of other people do and it's usually...
January 22, 2024 at 4:52 am
Well you can test that too.
My point is... the OP hasn't identified the scenario accurately enough to even try to determine which kind of testing needs to be done.
January 20, 2024 at 5:42 pm
Be careful when testing. In this case, the OP hasn't defined what he means by "Assume I'm going to insert lots of data". Does that mean for just one, multi-row...
January 20, 2024 at 3:17 pm
Assume I have a table with a clustered datetime-index. Assume I'm going to insert lots of data. The data to be inserted is not in any specific order. Would...
January 19, 2024 at 3:18 pm
This isn't the right way to do things. You can easily get to the point of where your system is doing nothing but rollbacks. You could also be causing grave...
January 19, 2024 at 2:58 pm
I'm uncomfortable with ChatGPT. I've found that a lot of its answers are believable rather than correct.
Exactly. I summarize that as being "Confidently Incorrect" and, in that area, ChatGPT...
January 19, 2024 at 1:19 pm
While the AI is quite capable of explaining exactly WHAT the code does programmatically, it's simply not capable of figuring out the WHY for most code. For example, the AI...
January 19, 2024 at 1:15 pm
From what I have seen the people I would regard as being at the top of their profession have certain traits.
January 19, 2024 at 1:00 pm
Not aimed at the author but aimed at the whole concept... Let's look at the first example prompt in the article...
You are an SQL Server database developer. Assume you...
January 19, 2024 at 5:01 am
Heh... let's look at the first paragraph in the article...
It's a good idea to learn more about different technologies. I've been amazed throughout my career, and even now as...
January 18, 2024 at 5:46 am
Not enough info... we're just guessing from descriptions. Please see the article at the 2nd link in my signature line below for what to post for these types of performance...
January 18, 2024 at 5:30 am
Possible solution to the original question...
Given the original example data...
Create Table #Payments (ID int, Comment Text)
INSERT INTO #payments values (1, '65607 Processed via? DISC Last 4 digits...
January 18, 2024 at 4:51 am
In this case I would start splitting the comment based on a space.
check "Tally OH! An Improved SQL 8K “CSV Splitter” Function"
and process the spliter results...
January 18, 2024 at 4:17 am
Viewing 15 posts - 796 through 810 (of 59,066 total)