Jeff Moden

Forum Replies Created

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

RE: PLE

GilaMonster - Sunday, August 27, 2017 2:06 PM
Arsh - Sunday, August 27, 2017 1:36 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 29, 2017 at 8:24 am

#1957247
RE: Right Size for LDF physical disk

luismarinaray - Saturday, August 26, 2017 5:49 PM
Jeff,
LDF file 507.965 Mb
Drive 507.974 Mb
free 9 mb
Thanks for your suggestions
If I'm reading that...
--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 9:27 am

#1957110
RE: Are the posted questions getting worse?

GilaMonster - Monday, August 28, 2017 7:37 AM
Jeff Moden - Monday, August 28, 2017 7:33 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 28, 2017 at 7:52 am

#1957085
RE: Lookup values similar to VLookUp in Excel

JJR333 - Monday, August 28, 2017 4:17 AM
Thank you Jeff, great!
Cheers,
Julian
(https://www.red-gate.com/simple-talk/sql/t-sql-programming/sql-server-apply-basics/)

DECLARE @IDHUIS VARCHAR(4)
DECLARE @IDAFD VARCHAR(4)
DECLARE @JAAR INT
DECLARE @WEEKBEGIN INT
DECLARE...
--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:40 am

#1957082
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

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