Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,971 through 20,985 (of 59,098 total)

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
RE: Is temporary table creation and dropping logged anywhere in SQL SERVER?

GilaMonster (4/20/2015)
Jeff Moden (4/20/2015)
GilaMonster (4/20/2015)
The default trace does log temp table creates and drops.
Awesome!
Not usually. 🙂
It's one reason why the default trace sometimes covers such a short time period....
--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:05 am

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

ankithimmatlalshah (4/20/2015)
Hello Phil,
I'm really sorry, it's yourself only.
Instead of Phil I specified Chris in my previous reply.
Client has provided one PDF file that contains the details about each column for...
--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:03 am

#1792445
RE: Embrace Stored Procedures

Charles Kincaid (4/21/2015)
We have been out of 9 digit Social Security Numbers for quite a while. Old ones are being reissued making the whole identity theft thing even harder 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)

April 21, 2015 at 8:55 am

#1792440
RE: Embrace Stored Procedures

TomThomson (4/20/2015)
Interesting discussion.
I think Conery's article is excellent, never mind the phrasing look at what is being said.
It's a pity that some people seem to believe that using stored procedures...
--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:39 am

#1792429

Viewing 15 posts - 20,971 through 20,985 (of 59,098 total)