Viewing 15 posts - 31 through 45 (of 3,665 total)
I would create a new package executes each of these packages in the required sequence.
September 2, 2016 at 3:41 pm
The easiest way I can imagine doing this is by using the error output to store the rows that erred out and use that stored output as in put for...
August 31, 2016 at 8:34 am
Sue_H (8/30/2016)
Joining Dev Essentials is free so you may...
August 31, 2016 at 7:25 am
I think the argument against store procedure sounds a lot like someone saying we should not use screws because their preferred tool is a hammer.
August 30, 2016 at 7:56 am
Columns are read or written in the order they are defined in the connection manager. If you're having a problem with the order, check the connection manager.
August 29, 2016 at 8:19 pm
Does the spreadsheet have column names that are used more than once?
August 29, 2016 at 3:43 pm
Luis Cazares (8/25/2016)
Sean Lange (8/25/2016)
Grant Fritchey (8/25/2016)
Sean Lange (8/25/2016)
Grant Fritchey (8/25/2016)
Lynn Pettis (8/25/2016)
Got to the following from a LinkedIn email. Not sure about a few of the answers.https://intellipaat.com/interview-question/sql-interview-questions/
I posted...
August 25, 2016 at 2:22 pm
Sean Lange (8/25/2016)
Grant Fritchey (8/25/2016)
Sean Lange (8/25/2016)
Grant Fritchey (8/25/2016)
Lynn Pettis (8/25/2016)
Got to the following from a LinkedIn email. Not sure about a few of the answers.https://intellipaat.com/interview-question/sql-interview-questions/
I posted a comment....
August 25, 2016 at 2:18 pm
Grant Fritchey (8/25/2016)
Alvin Ramard (8/25/2016)
Grant Fritchey (8/25/2016)
Lynn Pettis (8/25/2016)
Got to the following from a LinkedIn email. Not sure about a few of the answers.https://intellipaat.com/interview-question/sql-interview-questions/
Holy crap. I can't wait to...
August 25, 2016 at 2:05 pm
You need to look at the process, or processes, that update/rebuild your dimensions and facts and resolve the issue there.
August 25, 2016 at 2:02 pm
Grant Fritchey (8/25/2016)
Lynn Pettis (8/25/2016)
Got to the following from a LinkedIn email. Not sure about a few of the answers.https://intellipaat.com/interview-question/sql-interview-questions/
Holy crap. I can't wait to hear that statistics answer...
August 25, 2016 at 1:56 pm
First thing I would try is to delete the FTP task and then try to recreate it.
August 25, 2016 at 1:13 pm
CELKO (8/25/2016)
... The purpose of GUID and UUID is to locate something that is external to the database. It is never intended for internal use inside the schema. ...
Oh...
August 25, 2016 at 12:20 pm
Luis Cazares (8/25/2016)
Alvin Ramard (8/25/2016)
Would this work?
LEFT(REPLACE(CAST(NEWID () AS NVARCHAR(MAX)), '-', '') , 15)I'm not sure if that will return unique strings. Although, the chance for duplicates is low.
Good point...
August 25, 2016 at 10:41 am
JALLYKAMOZE (8/25/2016)
Alvin Ramard (8/25/2016)
JALLYKAMOZE (8/25/2016)
Alvin Ramard (8/25/2016)
CREATE TABLE DELAYSECONDS(
ProgramID INT, ID...
August 25, 2016 at 10:37 am
Viewing 15 posts - 31 through 45 (of 3,665 total)