Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,671 through 17,685 (of 59,102 total)

RE: Executing Exe in C# using SSIS Execute Process Task

adhikari707 (5/18/2016)
I have a exe that i am calling from SSIS execute Process Task.
Inside exe there is logic that i want to control by passing 2 parameters "DaysFrom" and "DaysTo".
Curious......
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 18, 2016 at 6:38 pm

#1880069
RE: take some data from excel through sql

sestell1 (5/18/2016)
Darn, it looks like that uses the MS Office API to connect to the workbook and do the conversion. I was hoping for a command-line utility that does...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 18, 2016 at 5:26 pm

#1880064
RE: Are the posted questions getting worse?

Lynn Pettis (5/18/2016)
Tell me, is this (third post) just fixing the symptom, not the problem?
Yes... fixing the problem. And, yes, not grasping the symptom.
A table being 100% replaced like...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 18, 2016 at 5:21 pm

#1880063
RE: take some data from excel through sql

georgheretis (5/18/2016)
i am using the tool "XLS to CSV Converter' see attachment
Any chance of you attaching that as a ZIP file instead of a RAR file? Thanks.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 18, 2016 at 8:16 am

#1879883
RE: Is there any way to find who deleted the database

prasanname2005 (5/17/2016)
Issue : one job which runs for every 5 minutes failed today (completed successfully yesterday) with error one of the object database.dbo.Table was not found.
The database was not...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 18, 2016 at 12:04 am

#1879742
RE: Preview your Article/Script

Steve Jones - SSC Editor (5/17/2016)
That's likely not going to happen soon. Resource constrained and I haven't seen anyone else report paste issues in the editor.
Crud. I've tried it...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 17, 2016 at 5:04 pm

#1879719
RE: take some data from excel through sql

georgheretis (5/17/2016)
Hi
I have a problem
I want to have a .csv File with the following format , some fields like ‘actors’ , ‘directors’ , ‘date’ and ‘date of pomotion’
The problem is...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 17, 2016 at 8:39 am

#1879556
RE: Table to table copy performance mystery - 5 billions rows.

You have to do this wholesale copy job on a regular basis??? :blink:
If so, consider putting that table in a database of it's own and use synonyms to point to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 17, 2016 at 8:33 am

#1879554
RE: Preview your Article/Script

Steve Jones - SSC Editor (5/16/2016)
I agree. I think there was some issue with the permissions and getting this working, but I'll add this to the list.
It would also be...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 16, 2016 at 3:58 pm

#1879388
RE: Kill The Sessions

Iwas Bornready (5/16/2016)
Don't know why I didn't find this sooner. Thanks.
Ooooo.... be really careful here. Yes, it avoids killing things that are "Runnable" but it does not avoid killing...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 16, 2016 at 3:50 pm

#1879386
RE: Dynamic data masking feature

Thanks, Steve. I appreciate it.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 16, 2016 at 3:29 pm

#1879379
RE: Finding if there was CPU or memory pressure yesterday night

coolchaitu (5/16/2016)
A DBA maintenance job failed yesterday night. Is there a way to find if there was CPU or memory pressure when this job ran yesterday night..
Rather than jumping to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 16, 2016 at 3:15 pm

#1879376
RE: SSIS automation through command line

Hmmm... I consider the Kerberos "double hop problem" to be a security feature rather than a fault and have been asked to eliminate the "problem" many times and have simply...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 16, 2016 at 3:13 pm

#1879375
RE: Dynamic Data Masking

Iwas Bornready (5/16/2016)
It may serve us well for the HIPAA regs.
It'll be interesting to see what shakes out there. As stated in the article, it's not a form of...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 16, 2016 at 10:02 am

#1879308
RE: Are the posted questions getting worse?

Lowell (5/16/2016)
Complete non-sequitur here guys, but I'm rather pleased with myself.
I just got my MCSA after taking 70-463 Implementing a Data Warehouse in SQL Server 2012/2014.
I had set a mental...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 16, 2016 at 9:58 am

#1879307

Viewing 15 posts - 17,671 through 17,685 (of 59,102 total)