Viewing 15 posts - 811 through 825 (of 5,111 total)
I think I see your problem. You don't know what a number is!
No, I clearly know what one is; I'm afraid it's just you, Joe, that is in...
August 6, 2019 at 6:50 pm
No, Jeff, an identifier is by its very nature measured on a nominal scale. It is not an interval scale. It is not a ratio scale. It is not...
August 6, 2019 at 6:58 am
What was your answer first? It's no good us answering your interview questions for you, it's not us sitting the interview.
If you tell us what you think the answer is...
July 26, 2019 at 10:11 am
Personally i really would be looking to get rid of the CURSOR first; SQL Server performs awfully at iterative tasks and is far better at set based ones. If you...
July 25, 2019 at 11:37 am
How do i mark tasks i wish to make the Job Fail/Not to Fail if there is an ERROR while execution of the DFT?
The package will fail automatically if the...
July 25, 2019 at 9:28 am
Does anyone have any idea why this could be happening?
not without more information. If a ForEach Container is only looping 3 times, that means that there was only 3...
July 23, 2019 at 1:41 pm
Hi, I have just modified your query and, please find the below:-
-- converting durationinsecs into int and summing the value
SELECT Created, Name, Type, sum(cast (Durationinsecs as...
July 23, 2019 at 12:52 pm
What was your attempt with Package.Execute? My impression was the powershell version works the same way at the .net Package.Executefunction, and the documentation states there:
The Execute method calls the...
July 23, 2019 at 7:59 am
Bugs me that the only "officially" supported version of Ubuntu for SQL Server is still 16.04. Although 16.04 itself is an LTS version, and supported until 2021, a lot of...
July 22, 2019 at 4:13 pm
I'm not sure I follow your point about the foreign keys and truncation. A foreign key doesn't stop you truncating a table, it's having a foreign key referencing the table...
July 22, 2019 at 4:07 pm
This isn't something I've really done, I tend to "expose" the containers to the network using a bridge in LXD; therefore they show as an additional host on the network...
July 22, 2019 at 10:20 am
You mean these? https://www.sqlservercentral.com/forums/forum/sql-server-vnext
July 19, 2019 at 11:31 am
From what I've read, and I've not heard anyone say otherwise, this appears to only effect SQL Server 2014-2017, so not 2012 or prior (and not 2019?). The data engine...
July 18, 2019 at 3:20 pm
You can get the table names from INFORMATION_SCHEMA.TABLE
Seems this could be even better if you get rid of the Cursor, use a proper join, quote the objects and use...
July 18, 2019 at 11:04 am
Maybe you have the package's ForceExecutionResult Property has been set to Success?
July 18, 2019 at 10:43 am
Viewing 15 posts - 811 through 825 (of 5,111 total)