Viewing 15 posts - 31 through 45 (of 251 total)
Is your new server clustered or part of an "availability group"? I think those are the right terms, I'm not an expert on that.
If this is the case, and assuming...
May 12, 2020 at 2:06 pm
Using embedded SQL / ORMs means that the DB login needs to be given all necessary rights to perform all operations.
How is that different than not using an ORM?...
March 6, 2020 at 5:45 pm
I had a similar difficulty in explaining why I felt procs were preferable to EF.
By "EF" do you mean "Entity Framework" as in Microsoft? You do...
March 6, 2020 at 1:50 pm
(sorry, supposed to be a quote/reply)
March 6, 2020 at 1:49 pm
I had a similar difficulty in explaining why I felt procs were preferable to EF.
By "EF" do you mean "Entity Framework" as in Microsoft? You do realize that...
March 6, 2020 at 1:27 pm
Is your project in Visual Studio targeting the expected version of SQL Server? Right-click the project, choose "Properties" and check the "Target Platform". If it's not right then change it...
January 9, 2020 at 1:32 pm
Note that it says "a query". It is literally, as you say, running one query, not multiple queries. Your representation is a different use case.
I think you're being unnecessarily...
November 4, 2019 at 10:25 pm
ZZartin -
Getting a second page of data is not rerunning a query. It's getting more data from a single query. That is what is under discussion in this...
November 4, 2019 at 9:30 pm
Jeff -
There are other options out there. Databases that use multi-version read consistency do exactly what you are asking - present an accurate picture of the state of...
November 4, 2019 at 3:20 pm
It's all a matter of how likely a possibility.
Recipe for disaster? A better recipe would be trying to retrieve all 10 million records to your client in a "static"...
November 4, 2019 at 2:46 pm
Oh, what a recipe for disaster! Since you are requerying the data every time, you have NO WAY to know if the offset is still valid. You are going...
November 4, 2019 at 2:00 pm
I use SSIS quite a bit where I work and in general it's a pretty useful tool. What I've found though, is that it tends to work best when you...
November 4, 2019 at 1:41 pm
You cannot replace anything within nothing, NULL is not a value so if the OP's assumption of the column being NULL then there is nothing to replace!
Yeah, duh? I...
October 16, 2019 at 12:49 pm
Why the extra step of replacing the concatenated CR and LF? Doesn't replacing the individual CHARs suffice? That's how I've done it, and I'd like to know if there is...
October 15, 2019 at 1:39 pm
I guess the follow-up question is "what can I do about this?" I don't know the answer to that unfortunately. I don't use procs that update millions of rows (usually)...
May 13, 2019 at 12:32 pm
Viewing 15 posts - 31 through 45 (of 251 total)