Viewing 15 posts - 61 through 75 (of 8,733 total)
Just a thought you need to check the number of VLF's and which is the active one, this will indicate whether a shrink is actually possible.
VLFs are Virtual Log...
August 29, 2023 at 4:00 pm
Suggest you create a new file and file group, then move the objects from the old to the new filegroup. this way you won't have all the negative impacts introduced...
August 29, 2023 at 12:53 pm
NoLock for payments is great. Just send me an email and delete my account from your system and I'm fine with whatever you want to do.
TODO: Send NOLOCK to...
August 23, 2023 at 3:37 pm
Jeff, Tally tables aren't working and this RBAR thing is RIDICULOUS. No one understands you. Try to be more like the other DBAs, please.
@=)
He he he, THIS problem I...
August 23, 2023 at 3:33 pm
NOLOCK was the bane of my existence at my last company. My predecessor forced the devs to add nolock everywhere. And regardless of how many bugs and issues that...
August 23, 2023 at 3:22 pm
What I really wish was that after a company end-of-life's software that they have to license out the code for a third party to support those with valid licenses...
August 19, 2023 at 11:03 am
Whilst installing a new laptop, noted that the download link for sql 2019 developer has disappeared
That would be Microsoft's latest SLV policy 🙂
😎
SLV = Short Live Versions 🙂
Although this...
August 18, 2023 at 2:55 pm
Can you please elaborate on this statement: "One Sales Deed has many buyers and sellers."?
😎
Certainly, there is only a single property on each deed, and partial shares are defined within...
August 8, 2023 at 4:50 pm
He he he, guilty as charged, made the assumption that it was clear that I was referring to the binary variable sizes given the code I posted.
😎
This is one of...
August 8, 2023 at 11:10 am
Thanks, Jeff for this very good writeup (as always)! 😎
Just a quick point, DATETIME2 is defaulted to DATETIME2(7), not considered the same data type as DATETIME2(<>7), same goes...
August 7, 2023 at 4:35 pm
There is a start-up parameter that needs to be enabled for the Express version to enable the TCP/IP connections, cannot remember what that option is, but this should guide you...
August 7, 2023 at 4:28 pm
Thanks, Jeff for this very good writeup (as always)!
😎
Just a quick point, DATETIME2 is defaulted to DATETIME2(7), not considered the same data type as DATETIME2(<>7), same goes with the TIME...
August 7, 2023 at 2:23 pm
I've just reported one of those AI-generated "SQL Server is good because" essay posts as spam. Do others agree that this is the right thing to do?
Yes. I've...
July 10, 2023 at 4:09 pm
I've just reported one of those AI-generated "SQL Server is good because" essay posts as spam. Do others agree that this is the right thing to do?
I think it...
July 10, 2023 at 10:37 am
I'm thinking that you need to be more clear on the job description that you use to hire people... a LOT more clear. For more than...
June 26, 2023 at 6:26 pm
Viewing 15 posts - 61 through 75 (of 8,733 total)