Viewing 15 posts - 4,711 through 4,725 (of 59,067 total)
Heh... good lord. It's been so long since I looked at that built in report that I'd forgotten a couple major (IMHO) flaws it has...
First, It does NOT report the...
August 26, 2021 at 4:30 am
Be VERY aware that the Schema Changes History report is based on the "Default Trace". The default trace "file" is actually incredibly small. Even with the 6 they roll through,...
August 26, 2021 at 4:08 am
@stephen.aa ,
The bottom line here is that it looks like you might be coming to SQL Server from Oracle and I'll tell you that SQL <> SQL and, for sure,...
August 26, 2021 at 4:00 am
That and the also-prevviously-reported-fact that "Followers" and "Following" have also disappeared. Are you good folks actually doing anything to fix this and doing something to prevent such things from happening...
August 25, 2021 at 6:28 pm
big financial group - lots of sub companies/teams
Do YOU maintain all of those servers or do most of the sub-companies have someone taking care of business for their own...
August 25, 2021 at 6:22 pm
When I run the piece for creating #staging:
Column name or number of supplied values does not match table definition.
Thx,
I'd gotten interrupted while I was working on the code. I...
August 25, 2021 at 5:58 pm
Looking at the Clustered Index for the oeordlin_sql table, I'm a wee bit concerned (especially for insert and update performance) over having the leading column be in the...
August 25, 2021 at 5:36 pm
Heh... Welcome back again, JLS. As you can see, some things haven't changed. 😉
August 25, 2021 at 5:21 pm
You can do something like this with dbatools.
A little bit of PowerShell and you can script out all you're looking for.
Since there are a whole lot of individual...
August 25, 2021 at 5:14 pm
Is it anyway to see if ever existed in table, and if they did, how/when they were deleted?
If it happened kind of recently, you could read the transaction log...
August 25, 2021 at 5:11 pm
It IS small and I love it.
What do you folks do where you need 750 servers and half of those are "prod"?
August 25, 2021 at 4:59 pm
Why don't you ask this question in the original thread?
That's almost funny, Michael... how many times have we seen people say "start a new thread for a different question"...
August 25, 2021 at 3:47 am
Hello and welcome aboard. To get some really good help quickly, please read the article at the first link in my signature line below for how to create "readily consumable...
August 25, 2021 at 3:32 am
I don't use "solutions" in SSMS. They just seem to make life difficult. That's not a personal bit of experience, though. I never knew about them for the longest time...
August 25, 2021 at 3:26 am
In SQL Server, you have a couple of things working against you.
A table starting with a numeric digit is against the "normal naming convention" for objects in SQL server. It...
August 25, 2021 at 3:21 am
Viewing 15 posts - 4,711 through 4,725 (of 59,067 total)