Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,116 through 20,130 (of 59,072 total)

RE: Challenge - dynamically load any file

Abhijit More (7/13/2015)
Jeff I have considered excel as simple table format columns and rows...no formatting is consider in my scri[t. probably after some tweaking it may work:-)
Thanks for the feedback,...
--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)

July 13, 2015 at 9:05 am

#1812023
RE: Challenge - dynamically load any file

Lowell (7/13/2015)
lol Jeff that's evil;
i could do it with Excel Automation in a script task, but all the columns would end up being "column1" "column2" because the first row 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)

July 13, 2015 at 9:05 am

#1812021
RE: Data Loss or Downtime

kelly.bailey (7/13/2015)
I know this was a re-run of an old editorial, but...
How should people be using data? In general:
1) Big important strategic decisions should be made using...
--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)

July 13, 2015 at 9:01 am

#1812020
RE: Extract the titles from XML

TomThomson (7/13/2015)
Jeff Moden (7/13/2015)
The correct answer isn't actually available. The correct answer should be to "hunt down the moroff that used XML to transmit purely flat data and introduce...
--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)

July 13, 2015 at 8:49 am

#1812011
RE: data problem

Never mind... post deleted.
--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)

July 13, 2015 at 6:00 am

#1811930
RE: ldf of main db and tempdb keep increasing

Edward-445599 (7/13/2015)
dbcc opentran
showed an old transaction , killed it
You should now try to figure out what data is missing because of the rollback you just caused and who 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)

July 13, 2015 at 5:42 am

#1811923
RE: Challenge - dynamically load any file

Abhijit More (7/13/2015)
I have challenge where I received data from multiple sources in different formats such as excel, csv, flat file.
Now the challenge is I have to load any received...
--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)

July 13, 2015 at 5:39 am

#1811922
RE: Extract the titles from XML

The correct answer isn't actually available. The correct answer should be to "hunt down the moroff that used XML to transmit purely flat data and introduce him to high...
--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)

July 13, 2015 at 4:53 am

#1811910
RE: Recover DB without Log file.

I believe the point that Perry is trying to make is that not much you can try in this case is going to work. About the only thing that's...
--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)

July 13, 2015 at 4:35 am

#1811907
RE: Page Life Expectancy drops like a rock at several points throughout the day

mortalic (7/10/2015)
We just went live on 2014 a few weeks ago. Previously on 2008R2, we've noticed a few small differences in behavior for the different DB Engines.
This one I...
--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)

July 13, 2015 at 4:26 am

#1811906
RE: Are the posted questions getting worse?

GilaMonster (7/13/2015)
Yes, yes, yes, yes!!!!!!!!
Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony
Outstanding, Gail!
--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)

July 13, 2015 at 4:03 am

#1811901
RE: Data Loss or Downtime

David.Poole (7/12/2015)
I strongly suspect that in the event of a DR scenario the business would find out that certain non-critical systems were actually far more important than they realised.
The question...
--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)

July 13, 2015 at 12:55 am

#1811867
RE: I Feel Like a Magician

Steve Jones - SSC Editor (7/12/2015)
I thought so too, after banging my head on the wall for a day and a half. Eventually found that there are some issues with...
--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)

July 12, 2015 at 7:05 pm

#1811856
RE: I Feel Like a Magician

David.Poole (7/8/2015)
Microsoft, your product is mature, it is time to start sweating the small stuff
+ 1 billion! I've emblazoned one of your fine quotes in my head... I think...
--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)

July 12, 2015 at 6:59 pm

#1811855
RE: Problems importing CSV files using SSIS.

Orlando Colamatteo (7/11/2015)
Maybe it was oversold to you, I wasn't there, but XML does what is was designed to do. If you have to ship relational or hierarchical data structures...
--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)

July 11, 2015 at 2:59 pm

#1811825

Viewing 15 posts - 20,116 through 20,130 (of 59,072 total)