Viewing 15 posts - 91 through 105 (of 59,038 total)
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
Below script will use to get single table or multiple tables or all tables DB fragmentation details .
Hello and welcome aboard! I appreciate anyone that steps up to the...
February 25, 2025 at 10:22 pm
From the article:
"Essentially one mistake overrides everything else."
We had a saying in the Navy... "One 'Aw Shit' wipes out a thousand 'Attaboys' ".
And, it doesn't matter if it's for a...
February 24, 2025 at 4:19 am
Congratulations @jeff-moden Finally overtook the high priestess on the SSC overall leaderboard.
She did have a shedload of LIKEs. The "upgrade" on the site years ago hasn't...
February 21, 2025 at 9:35 pm
Congratulations @jeff-moden Finally overtook the high priestess on the SSC overall leaderboard.
She did have a shedload of LIKEs. The "upgrade" on the site years ago hasn't helped much either. ...
February 19, 2025 at 8:43 pm
In the ss below you can see that I have a table (dbo.clan.spouses) with a column (spousesID) that has a datatype of uniqueidentifier.
I assigned that value not knowing the...
February 18, 2025 at 9:36 pm
Viewing 15 posts - 91 through 105 (of 59,038 total)