Viewing 15 posts - 721 through 735 (of 59,066 total)
You could/should setup an Extended Event to capture anything (including code) that makes the log file grow. Of course, you'd have to shrink the log file to a reasonable size...
February 15, 2024 at 3:17 pm
You could/should setup an Extended Event to capture anything (including code) that makes the log file grow. Of course, you'd have to shrink the log file to a reasonable size...
February 15, 2024 at 3:14 pm
If I'm thinking the same way as you, just use SUM on each column with a GROUP BY on what you have in the left-most column.
Also, this isn't your first...
February 15, 2024 at 2:56 pm
Good day Experts,
How can i combine these two rows into one in sql .So i want it to be one row.
Many thanks
Sorry... not seeing any "sample...
February 15, 2024 at 2:53 pm
Bumping the previous post so that it actually shows up because of the "first post on a page" problem they haven't fixed on this forum yet. 🙁
February 15, 2024 at 2:51 pm
Yep, that's what I was thinking about. Thanks for clarifying! 🙂
I've had my head embedded in Postgres for the last few years. It's not surprising something got pushed out...
February 15, 2024 at 2:49 pm
It's not your first visit here so you should already know that, if you'd posted the data in a readily consumable format, you'd have a code-tested answer by now. 😉
I...
February 15, 2024 at 2:04 am
Any ideas on what I should do? I've been told it is similar to an 837 file.
With some good bit of work, the header version could be parsed but...
February 15, 2024 at 1:44 am
In times past, using varchar without a length defaulted to 30 characters. Did that change?
No. It hasn't changed. What it says in BOL has been true since I can...
February 15, 2024 at 1:06 am
maxdop is set to 1 at instance level and at database level it is set to 4. looks like each operator within plan is taking 4 threads
February 14, 2024 at 11:11 pm
Just in case you don't know him, Eirikur is one of the contributors to the DelimitedSplit8K function. He made a simple but important change to it after SQL Server 2012...
February 14, 2024 at 3:26 pm
I need a particular calculation done that is really hard to do in SS...
I've heard such a thing many times. The answer is always "No" unless you ask...
What is...
February 14, 2024 at 2:11 am
Testing complete. Unfortunately, it made zero difference in performance.
February 12, 2024 at 11:20 pm
Thank you both!
We had to upgrade because of "corporate policy". We were at 2016. 2017 doesn't have the horrible performance issues that 2019/2022 has. Even a super simple Tally function...
February 12, 2024 at 10:55 pm
Viewing 15 posts - 721 through 735 (of 59,066 total)