Viewing 15 posts - 811 through 825 (of 5,109 total)
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 22, 2019 at 10:20 am
You mean these? https://www.sqlservercentral.com/forums/forum/sql-server-vnext
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 18, 2019 at 11:04 am
Maybe you have the package's ForceExecutionResult Property has been set to Success?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 18, 2019 at 10:43 am
I want to separate money values in my tables with (/) character Also separate decimal by (") Character. Example: 2/498/489"25 help me please
I'll make you a deal......
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 17, 2019 at 1:34 pm
Viewing 15 posts - 811 through 825 (of 5,109 total)