Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,941 through 20,955 (of 59,072 total)

RE: Encryption Key not known

@sarah,
Seriously off topic but I have to ask... are you related to Ed Wagner on these forums?
--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)

April 22, 2015 at 9:42 am

#1792802
RE: How is MSBI market in India

super48 (4/21/2015)
Hello,
I have total 2.6 years experienced in ssis,ssrs,ssas.still I don't feel I have enough experience on these tools.
even though I have knowledge I didn't worked on many features...
--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)

April 22, 2015 at 9:41 am

#1792801
RE: Help needed- Generate 8 char Alphanumeric Unique Sequence

@ditha,
Tonight after work, I'm going to try to save your professional life. If you run any code that generates all 3+ billion rows, the table just for that one...
--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)

April 22, 2015 at 9:37 am

#1792797
RE: ETL Archive Issue, advice sought, please.

aaron.reese (4/22/2015)
@OP
so if you don't know what dates records were created/last updated, how would you choose records to be archived?
@JM
If someone changes the table structure, you are ~£%$!"$* :)...
--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)

April 22, 2015 at 9:27 am

#1792789
RE: ETL Archive Issue, advice sought, please.

Duran (4/22/2015)
Aaron,
Thanks for replying...
Do you have a field in each table that you can confidently rely upon to provide a monthly cut off, Or a field which provides a FK...
--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)

April 22, 2015 at 9:26 am

#1792788
RE: Is it possible to load multiple flat files into table without using foreach loop container?

p.shabbir (4/21/2015)
Phil Parkin (4/21/2015)
p.shabbir (4/21/2015)
Hi phil,
Thanks for the quick response. I know that one DFT per file will do but, what if we have more files(Say 50 or 100 files)....
--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)

April 22, 2015 at 9:22 am

#1792785
RE: Illegal CTEs

Ed Wagner (4/21/2015)
PHYData DBA (4/21/2015)
sknox (4/21/2015)
Great. Now I'm trying to conceive of a situation where one would want to use PIVOT within a recursive CTE... :blink:
Stop that. Just... NO! :hehe:
What...
--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)

April 22, 2015 at 8:53 am

#1792766
RE: SSIS 2008 – Read roughly 50 CSV files from a folder, create SQL table from them dynamically, and dump data.

axissolutionspl (4/22/2015)
Actually, I followed the excellent blog by Marco Schreuder here: http://blog.in2bi.com/biml/creating-a-meta-data-driven-ssis-solution-with-biml-1-overview/
Yes there is a bit of learning, but if you just use his example as starting point is 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)

April 22, 2015 at 8:47 am

#1792762
RE: ETL Archive Issue, advice sought, please.

So what's supposed to happen if someone adds a column to a table or an index?
--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)

April 21, 2015 at 11:02 pm

#1792615
RE: T-SQL Coding - How do you code error handling logic in your SQL Server stored procedures?

I find that many people don't actually know how to write Try/Catch. What they end up doing is throwing the same error but in a manner that obfuscates where...
--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)

April 21, 2015 at 10:39 pm

#1792614
RE: very slow INSERT to #tmptable

joepositive (4/21/2015)
Jeff Moden (4/21/2015)
Just a curious shot in the dark on this... what is the default collation of the database you're select from and what is the default collation 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)

April 21, 2015 at 8:23 pm

#1792607
RE: Embrace Stored Procedures

Andrew..Peterson (4/21/2015)
rmechaber (4/21/2015)
I feel like I'm on a Fark.com comment thread and should be making a snarky comment about making popcorn.
Are we really still having this conversation in 2015 about...
--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)

April 21, 2015 at 8:18 pm

#1792605
RE: SSIS 2008 – Read roughly 50 CSV files from a folder, create SQL table from them dynamically, and dump data.

axissolutionspl (4/21/2015)
Greetings to all experts in this forum, this is my first post.
Recently, I was given similar task except that we do have the field names and data types on...
--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)

April 21, 2015 at 8:13 pm

#1792604
RE: Use cursor to run dynamic SQL to find special characters used in database

ScottPletcher (4/20/2015)
Doesn't have to be an iTVF, you can still use dynamic SQL, just process all columns in a given table in one statement, not multiple.
True Dat! 🙂
--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)

April 21, 2015 at 8:09 pm

#1792603
RE: The Elusive Conditional WHERE Clause

peter-757102 (4/21/2015)
Even with some of the harsh feedback that comes with publishing I feel the need to write at least one article myself.
Certainly I owe many of the previous writers...
--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)

April 21, 2015 at 9:54 am

#1792466

Viewing 15 posts - 20,941 through 20,955 (of 59,072 total)