Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,181 through 15,195 (of 59,101 total)

RE: EXCEL HELL!!!

grovelli-262555 - Thursday, April 13, 2017 9:12 AM
Thanks
"I wrote one in T-SQL and made a "trial" presentation of the technique for my...
--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)

April 13, 2017 at 9:47 pm

#1938137
RE: No PKs on fact tables

jcelko212 32090 - Thursday, April 13, 2017 12:36 PM
Lynn Pettis - Thursday, April 13, 2017 12:01 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)

April 13, 2017 at 9:41 pm

#1938136
RE: Need Logic

In the long run, it would probably be cheaper and better to just buy a monitoring product if you're going to do that level of measuring and reporting. I 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)

April 13, 2017 at 2:26 pm

#1938128
RE: Table size and indexes

GilaMonster - Wednesday, April 12, 2017 2:02 PM
NineIron - Wednesday, April 12, 2017 11:37 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)

April 13, 2017 at 2:19 pm

#1938127
RE: Improving performance using partitioning

nadersam - Thursday, April 13, 2017 7:05 AM
Sorry , which URL do you mean?
I posted it again as zip file.
Thanks
Thanks... not sure...
--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)

April 13, 2017 at 7:29 am

#1938039
RE: Improving performance using partitioning

nadersam - Thursday, April 13, 2017 6:29 AM
There was a missing script for one of the objects i reattached it here.
Sorry about...
--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)

April 13, 2017 at 6:50 am

#1938027
RE: No PKs on fact tables

jcelko212 32090 - Monday, April 3, 2017 12:55 PM
Welcome to the real world where people did not learn RDBMS! And, and...
--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)

April 13, 2017 at 6:47 am

#1938026
RE: Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

thisisfutile - Wednesday, April 12, 2017 3:28 PM
Jeff Moden - Sunday, April 2, 2017 7:20 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)

April 12, 2017 at 3:53 pm

#1937955
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Ed Wagner - Wednesday, April 12, 2017 1:30 PM
Eric M Russell - Wednesday, April 12, 2017 11:30...
--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)

April 12, 2017 at 3:44 pm

#1937953
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Eirikur Eiriksson - Wednesday, April 12, 2017 11:36 AM
Eric M Russell - Wednesday, April 12, 2017 11:30...
--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)

April 12, 2017 at 3:42 pm

#1937952
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Eirikur Eiriksson - Wednesday, April 12, 2017 9:35 AM
Chipping in, it is also a matter of code portability as using 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)

April 12, 2017 at 11:18 am

#1937905
RE: Parse numbers from Column

jcelko212 32090 - Wednesday, April 12, 2017 11:03 AM
Which "Yard of Ale" are you drinking? US, British, Queen Ann, etc? My...
--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)

April 12, 2017 at 11:09 am

#1937904
RE: EXCEL HELL!!!

grovelli-262555 - Wednesday, April 12, 2017 8:33 AM
"my "Excel Hell" presentation last night"
Was that an online presentation?
No. It was in-person at 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)

April 12, 2017 at 9:26 am

#1937878
RE: Import from File

maudzedunjp - Wednesday, April 12, 2017 5:12 AM
In this case it is better to work with someone intelligent
You should take your own...
--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)

April 12, 2017 at 8:56 am

#1937868
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

AnthonyR - Tuesday, April 11, 2017 11:44 PM
Jeff Moden - Tuesday, April 11, 2017 8:42 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)

April 12, 2017 at 8:47 am

#1937866

Viewing 15 posts - 15,181 through 15,195 (of 59,101 total)