Viewing 15 posts - 136 through 150 (of 59,078 total)
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
Here's the section of the documentation that seems to apply here and it's in the form of step-by-step instructions. I do NOT know for sure if this will prevent DBAs...
February 17, 2025 at 1:12 am
I had to modify the script (added a couple of columns in @FileList and @DbNameHeaders) and added some more logic to suit my needs.
This script works like charm in...
February 17, 2025 at 1:02 am
As for not being able to see the column you added in the design view, it sounds like you did all the proper refreshes and so I have to ask,...
February 17, 2025 at 12:52 am
This is NOT a problem with code. It IS a setting in SSMS to prevent casual users from making changes using the Object Explorer. Unfortunately, it's an instance wide setting...
February 17, 2025 at 12:43 am
The error message is...
Msg 8114, Level 16, State 5, Line 12
Error converting data type varchar to numeric.
... and I'm surprised that this doesn't fail in Sybase but I don't...
February 17, 2025 at 12:22 am
Viewing 15 posts - 136 through 150 (of 59,078 total)