Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,876 through 19,890 (of 59,072 total)

RE: Errors when inserting rows from a linked server

g.britton (8/15/2015)
On topic but slightly different subject, what is the purpose for having 548 MAX columns? Not a challenge, Gerald... just curious.
wish I knew! I've been asked 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)

August 15, 2015 at 7:07 am

#1820280
RE: Errors when inserting rows from a linked server

On topic but slightly different subject, what is the purpose for having 548 MAX columns? Not a challenge, Gerald... just 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)

August 14, 2015 at 9:28 pm

#1820264
RE: Are the posted questions getting worse?

The good part about it is that all hardware has had to become bigger, faster, and cheaper to be able to handle even just the tag bloat never mind the...
--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)

August 14, 2015 at 7:01 pm

#1820262
RE: Help Needed in Processing Data

Heh... I thought it might be a little more complicated than what your first post suggested.
For these types of things, I don't use SSIS but you might want to because...
--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)

August 14, 2015 at 6:40 pm

#1820260
RE: Are the posted questions getting worse?

Eirikur Eiriksson (8/14/2015)
Jeff Moden (8/14/2015)
Heh... since it's for XML...
Trying to put my finger on this, just cannot find which kind of XML phobia is plaguing you Jeff:Whistling:, so far I've...
--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)

August 14, 2015 at 5:47 pm

#1820257
RE: Which is Best to use, #Temp Table or @Table Variable?

GilaMonster (8/14/2015)
Gary Harding (8/14/2015)
Can you define a nonclustered index on a non-unique set of columns in a table variable?
No, at least not before SQL 2014, but you can always...
--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)

August 14, 2015 at 5:22 pm

#1820256
RE: The Tally Table

Alan.B (8/14/2015)
BobAtDBS (8/14/2015)
I have read Jeff's article, both in the past and an hour ago. His examples aren't things we do at the TSQL level very often. I'm...
--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)

August 14, 2015 at 5:18 pm

#1820254
RE: Unable to link data from data pulled from XML

Easy now, folks. These types of things are how we all learn. 😉 Well, except for me. I reject all XML whenever I can. 😛
--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)

August 14, 2015 at 1:58 pm

#1820216
RE: Are the posted questions getting worse?

Eirikur Eiriksson (8/14/2015)
Ed Wagner (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Alvin Ramard (8/14/2015)
Eirikur Eiriksson (8/14/2015)
SQLRNNR (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Sometimes one wonders what drives the responds when one points out that the posted solutions are 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)

August 14, 2015 at 1:54 pm

#1820214
RE: Help Needed in Processing Data

KGJ-Dev (8/14/2015)
Hi Jeff,
thanks for the reply. I have another idea. How about writing c# code to read the text file and dump it in intermediate table with the way 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)

August 14, 2015 at 1:31 pm

#1820209
RE: The Tally Table

Lynn Pettis (8/14/2015)
g.britton (8/14/2015)
What's the purpose of doing a cross join between the master.dbo.syscolumns table, and then not using it? Sorry, inquiring minds want to know.
to get enough numbers 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)

August 14, 2015 at 1:00 pm

#1820203
RE: The Tally Table

Rod at work (8/14/2015)
Oh OK Luis, I get it now. I got hung up on trying to read what's in syscolumn. That's not the point at all, is it. The...
--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)

August 14, 2015 at 12:54 pm

#1820200
RE: The Tally Table

BobAtDBS (8/14/2015)
I have read Jeff's article, both in the past and an hour ago. His examples aren't things we do at the TSQL level very often. I'm wondering...
--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)

August 14, 2015 at 12:49 pm

#1820196
RE: The Tally Table

g.britton (8/14/2015)
Alan.B (8/14/2015)
g.britton (8/14/2015)
I just wish it wasn't called a "Tally" table. I don't tally things, I count them. fwiw I usually call my "tally" table "N" to reflect...
--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)

August 14, 2015 at 12:42 pm

#1820193
RE: Which is Best to use, #Temp Table or @Table Variable?

Eric M Russell (8/13/2015)
I wish that temp tables and table variables were simply non-transacted.
I'll strongly second that wish. I also wish that there were a way to mark certain...
--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)

August 14, 2015 at 8:49 am

#1820084

Viewing 15 posts - 19,876 through 19,890 (of 59,072 total)