Jeff Moden

Forum Replies Created

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

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
RE: EXCEL HELL!!!

pharryecoenen - Wednesday, April 12, 2017 7:48 AM
Does you update "Excel Hell" also work in later versions of SQL (the column...
--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:14 am

#1937848
RE: Parse numbers from Column

jcelko212 32090 - Tuesday, April 11, 2017 12:23 PM
dba-512085 - Friday, April 7, 2017 4:16 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 7:47 am

#1937840
RE: EXCEL HELL!!!

pharryecoenen - Wednesday, April 12, 2017 4:58 AM
My heart jumped, as for a moment I thought MS had created new JET...
--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 7:38 am

#1937837
RE: Are the posted questions getting worse?

jasona.work - Tuesday, April 11, 2017 1:46 PM
Just was looking in the topic on using Numeric as a Primary Key...
I know 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)

April 11, 2017 at 8:52 pm

#1937747

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