Viewing 15 posts - 91 through 105 (of 8,760 total)
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
I agree with Eirikur on all this... I believe that a whole lot of people resort to the likes of Python because they don't actually know how to use...
May 18, 2023 at 4:50 pm
why they thought SQL couldn't be used to do any of those things.
He he, first guess is that they don't know how to!
😎
May 14, 2023 at 3:34 pm
I have to say that if we did mix the good things of all of them we would have an really really outstanding product.
So... what are you waiting...
April 11, 2023 at 2:24 pm
Suggest you describe what you are doing step by step.
😎
So far we got the following knowledge:
1. Data conversion failure on import (error)
2. MS Access database as the source
3. SQL Server...
April 3, 2023 at 12:01 pm
Viewing 15 posts - 91 through 105 (of 8,760 total)