Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,506 through 14,520 (of 59,097 total)

RE: Are the posted questions getting worse?

DesNorton - Sunday, August 27, 2017 11:56 PM
Jeff Moden - Saturday, August 26, 2017 2:17 PM
--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 28, 2017 at 7:33 am

#1957079
RE: Data flow concept - Thoughts wanted

Jeff Moden - Monday, August 28, 2017 7:21 AM
Orlando Colamatteo - Sunday, August 27, 2017 9:34 PM
--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 28, 2017 at 7:22 am

#1957076
RE: Data flow concept - Thoughts wanted

Orlando Colamatteo - Sunday, August 27, 2017 9:34 PM
Hi Tom, One other thing to consider...has your company talked about moving any...
--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 28, 2017 at 7:21 am

#1957075
RE: Columns to rows and rows to column conversion without pivot/unpivot

Jason A. Long - Saturday, August 26, 2017 8:18 PM
Jeff, It's always fun to see the same question posted on 2 different...
--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 27, 2017 at 12:51 pm

#1957021
RE: PLE

Arsh - Sunday, August 27, 2017 12:10 PM
GilaMonster - Sunday, August 27, 2017 8:59 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 27, 2017 at 12:31 pm

#1957020
RE: Lookup values similar to VLookUp in Excel

Maybe I can save you some time...
The following code works just fine but it has than nasty ol' Triangular Join in it.

ALTER...
--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 27, 2017 at 12:06 pm

#1957018
RE: Lookup values similar to VLookUp in Excel

Ok... understood on the VLookup thing. I forgot that it's a "range" calculation behind the scenes (it's been almost 2 decades since I've used one) that returns the row with 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 27, 2017 at 10:56 am

#1957013
RE: The art of getting it right

Good article. One of the things you indirectly brought up was "reputation". Not only does the DBA have a reputation but the company has a reputation. I'm get angry when...
--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 26, 2017 at 6:47 pm

#1956991
RE: PLE

Arsh - Saturday, August 26, 2017 8:35 AM
Hi All,Appreciate if anybody can help understand why the physical memory is divided by 4...
--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 26, 2017 at 5:51 pm

#1956988
RE: Why did added partitions make cube processing slower?

GilaMonster - Monday, August 21, 2017 12:51 AM
For those mentioning index maintenance, queries, etc, the OP's asking about partitions of Analysis Services...
--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 26, 2017 at 5:36 pm

#1956985
RE: Columns to rows and rows to column conversion without pivot/unpivot

First, you should learn to post readily consumable data instead of just plain text. Please see the first link under "Helpful Links" in my signature line below. People will answer...
--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 26, 2017 at 5:24 pm

#1956984
RE: Modeling relational databases

To be honest, I usually tell auditors "NO" when it comes to producing a full system ERD. They usually don't have the need to know and it is a proprietary system. ...
--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 26, 2017 at 4:42 pm

#1956983
RE: Right Size for LDF physical disk

luismarinaray - Friday, August 25, 2017 1:44 PM
Dear friends,
Please, help me to take action, the facts are:
Big database 1.5 terabyte database size,...
--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 26, 2017 at 4:31 pm

#1956982
RE: Lookup values similar to VLookUp in Excel

JJR333 - Saturday, August 26, 2017 6:16 AM
Hi,
I am struggling to write a procedure which looks up a value in 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 26, 2017 at 4:25 pm

#1956981
RE: Are the posted questions getting worse?

Sean Lange - Friday, August 25, 2017 11:54 AM
Boy the forums are getting buggier all the time. I have had several notifications...
--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 26, 2017 at 2:17 pm

#1956978

Viewing 15 posts - 14,506 through 14,520 (of 59,097 total)