Viewing 15 posts - 31 through 45 (of 247 total)
(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
Regarding why it's slower in SSIS...SSIS needs to "validate" your query (in this case a stored procedure). It has to get metadata about the query in order to validate that...
May 13, 2019 at 12:29 pm
I sent you a private message earlier, wasn't able to reply in forum due to getting an error.
What exactly did you try and what are you using (what tool/app) to...
April 25, 2019 at 6:21 pm
Yeah I went through this with SSIS/SSDT.
That error refers to the "Microsoft Access Database Engine 2010 Redistributable" I think. You can download that from here:
https://www.microsoft.com/en-in/download/details.aspx?id=13255
There are different versions of...
April 24, 2019 at 12:32 pm
Viewing 15 posts - 31 through 45 (of 247 total)