Viewing 15 posts - 106 through 120 (of 59,058 total)
Thank you, have you managed to get past the performance issues as a result of the version upgrade? Do you possibly have any links you can share on why...
March 3, 2025 at 3:39 pm
The error is telling you what is wrong. Also, if you go to the KB article, it will also tell you what is wrong. It's saying that the instances where...
March 3, 2025 at 1:56 am
I just want them to fix the serious performance problems that started in 2019 and they've done (apparently) nothing to fix even up 'til today for SQL Server 2022. 🙁
March 1, 2025 at 2:01 am
Yes... but it won't help... Stand up your 2022 server and do some restores and then do test runs against your old server and the new one. The tests should...
February 28, 2025 at 6:49 pm
Heh... and people wonder why such a thing won't stand up in court. Ant-Green is spot on!
February 26, 2025 at 11:42 pm
I appreciate your honest replies and your professionalism in wanting to help others as you learn. That's pretty much the spirit for most of the long term denizens of this...
February 26, 2025 at 11:39 pm
I am curious how it (GENERATE_SERIES function)performs compared to the tally table.
It's nasty fast. It's not as flexible as you'll find in other flavors of SQL because it "only"...
February 26, 2025 at 8:50 pm
That trigger was placed there for a reason.
In financing terms once something is on a journal / ledger, it should ALWAYS remain on that journal / ledger.
If there was...
February 26, 2025 at 5:27 pm
Largely speaking, I've thus far not used any of the various and sundry "AI" implementations out there (either for SQL or anything else,) mostly because, well, I don't see...
February 26, 2025 at 5:22 pm
Decades of change and experimentation just to find out that SQLServerCentral remains one of the best online forums.
The system won't let me give that comment the million or so...
February 26, 2025 at 2:27 am
Hi, John. Gosh... it's been a long time since we've seen each other in person.
Nice article and thank you for the honorable mention.
Just to add a bit of a clarification,...
February 26, 2025 at 2:20 am
The conversation about all of that seems like it started on LinkedIn. IIRC, they were announcing that CoPilot was coming out as a part of a new release of SSMS...
February 26, 2025 at 1:57 am
The post is fine and appropriate. It also introduces some of the meta-data available about tables and a couple of things.
I have a couple of questions for you, though....
February 26, 2025 at 12:31 am
If those backup drives are on the same system as your SQL Server, you need to move them to a different machine, ASAP.
Also, why are you using SQLCMD to do...
February 26, 2025 at 12:08 am
Thanks, Jeff.
I learned a good deal from your post. I did not know about the square brackets syntax requirement. I also learned more about using schema.
Thanks, again.
My pleasure and...
February 25, 2025 at 10:35 pm
Viewing 15 posts - 106 through 120 (of 59,058 total)