Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,491 through 11,505 (of 59,095 total)

RE: Long Formats

My answer would be ... don't do this in R. 😀 It's simple to do in T-SQL. And it's funny a bit... you've nicely covered up the word "EAV" 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)

August 17, 2018 at 7:36 am

#2002231
RE: Huge number of tables

aaron.reese - Friday, August 17, 2018 6:20 AM
and I expect in any given installation 50K of them are empty 🙂
Except on Tuesdays....
--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 17, 2018 at 6:48 am

#2002217
RE: How to a use a temp table as a destination for a dataflow in SSIS

andycadley - Thursday, August 16, 2018 1:15 PM
For what it's worth, the "right to forget" in the GDPR does not apply if...
--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 17, 2018 at 6:31 am

#2002215
RE: How to a use a temp table as a destination for a dataflow in SSIS

Shifting gears on all of this a bit... the "lesser" site (the one that does NOT have the forgotten data) should not be doing the data "pull", IMHO. To 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)

August 16, 2018 at 9:52 pm

#2002179
RE: How to a use a temp table as a destination for a dataflow in SSIS

FunkyDexter - Thursday, August 16, 2018 11:14 AM
Blimey, loads of stuff to respond to. Thanks for all the input folks.
A bit 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)

August 16, 2018 at 9:49 pm

#2002178
RE: How to a use a temp table as a destination for a dataflow in SSIS

Thom A - Thursday, August 16, 2018 9:21 AM
You could, if you wanted, create the table in tempdb. Although it's not a...
--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 16, 2018 at 9:29 am

#2002099
RE: How to a use a temp table as a destination for a dataflow in SSIS

FunkyDexter - Thursday, August 16, 2018 8:08 AM
So can I use a temp table in this way?
You can if you do...
--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 16, 2018 at 8:53 am

#2002091
RE: Are the posted questions getting worse?

jonathan.crawford - Thursday, August 16, 2018 8:18 AM
In "Lives Of A Cell", Lewis Thomas postulates that Language is really...
--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 16, 2018 at 8:28 am

#2002079
RE: Why QUOTENAME is important

RonKyle - Thursday, August 16, 2018 7:33 AM
Jeff Moden - Thursday, August 16, 2018 7:06 AM
--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 16, 2018 at 8:21 am

#2002077
RE: Why QUOTENAME is important

RonKyle - Thursday, August 16, 2018 6:33 AM
This also applies to Jeff's comments. The original comment said a simple check...
--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 16, 2018 at 7:06 am

#2002053
RE: Are the posted questions getting worse?

JustMarie - Tuesday, August 14, 2018 1:59 PM
And this is why I drink....
Four months ago I told my boss that I need...
--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 16, 2018 at 6:38 am

#2002042
RE: 2 identical plans - different performance when query run on different servers

PearlJammer1 - Thursday, August 16, 2018 3:21 AM
Hi
Thanks to everyone for their help and suggestions. I have managed to fix the issue....
--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 16, 2018 at 6:25 am

#2002036
RE: Why QUOTENAME is important

Thom, thanks again for taking the time to write this article. It's not only a great "Back to Basics" article but it turned out to be an "I Learned Something...
--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 16, 2018 at 6:07 am

#2002033
RE: SQL Server 2016 - Catching Up Since SQL Server 2008R2

YSLGuru - Tuesday, August 14, 2018 11:08 AM
We are moving from SQL 2008R2 to 2016 and needless to say I'm not up...
--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, 2018 at 12:10 pm

#2001956
RE: Why QUOTENAME is important

RonKyle - Wednesday, August 15, 2018 7:52 AM
Thom A - Wednesday, August 15, 2018 7:42 AM
--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, 2018 at 11:27 am

#2001944

Viewing 15 posts - 11,491 through 11,505 (of 59,095 total)