Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,351 through 10,365 (of 59,099 total)

RE: Suggestion on import data

girl_bj - Sunday, December 16, 2018 6:38 PM
Hi,
Every month I will import data into table. The data doesn't have any primary key....
--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)

December 17, 2018 at 7:36 am

#2016507
RE: how to speed retrieving data from big table data when select from it?

Indexes aren't going to help much here. The OP is trying to return most of the table to the screen and there are a million rows in the table. What...
--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)

December 17, 2018 at 7:30 am

#2016505
RE: PERCENTILE_DISC for median calculation

valeryk2000 - Sunday, December 16, 2018 8:09 PM
Jeff Moden - Sunday, December 16, 2018 7:56 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)

December 16, 2018 at 9:28 pm

#2016442
RE: PERCENTILE_DISC for median calculation

valeryk2000 - Sunday, December 16, 2018 7:00 PM
Jeff Moden - Sunday, December 16, 2018 5:37 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)

December 16, 2018 at 7:56 pm

#2016438
RE: PERCENTILE_DISC for median calculation

One more BTW.... I was going to test performance of the PERCENTILE_CONT function against some other methods. With the disclaimer that I've not verified the testing (and it DOES 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)

December 16, 2018 at 5:37 pm

#2016433
RE: PERCENTILE_DISC for median calculation

BTW... the way to get the code to display without all the extra blank lines in it is to copy'n'paste the code into NOTEPAD first. Then, copy'n'paste from NOTEPAD to...
--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)

December 16, 2018 at 5:27 pm

#2016432
RE: PERCENTILE_DISC for median calculation

Heh.... lordy. I just reread BOL for PERCENTILE_DISC ("disc" means "discrete").. It INTENTIONALLY works the way your tests came out. Here's the description found at the official MS documentation at...
--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)

December 16, 2018 at 4:47 pm

#2016429
RE: PERCENTILE_DISC for median calculation

valeryk2000 - Sunday, December 16, 2018 2:57 PM
Same result:
2.00000
~~Yowch. That's just not right. Thank you very much for testing. I should be able to...~~
--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)

December 16, 2018 at 3:59 pm

#2016428
RE: Are the posted questions getting worse?

xsevensinzx - Sunday, December 16, 2018 3:22 PM
Was reading an article when I came across this excerpt. Figured the community would enjoy...
--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)

December 16, 2018 at 3:53 pm

#2016427
RE: PERCENTILE_DISC for median calculation

Ah... I think I found it. From BOL...
Return Types
The return type is determined by the order_by_expression type.
--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)

December 16, 2018 at 1:35 pm

#2016422
RE: PERCENTILE_DISC for median calculation

valeryk2000 - Sunday, December 16, 2018 12:50 PM
PERCENTILE_DISC (0.5) does not provide the median for EVEN number of records. Only for ODD...
--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)

December 16, 2018 at 1:28 pm

#2016421
RE: Basic Question: Do you have to restart the instance if you change database or log file growth

To be honest, I actually prefer Paritioned Views over Partitioned Tables. Try restoring just 3 months of a Partitioned Table to another server sometime and you'll
see what I...
--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)

December 16, 2018 at 1:15 pm

#2016418
RE: Automaticaly Build and Deploy SSIS packages.

Phil Parkin - Sunday, December 16, 2018 12:15 PM
Jeff Moden - Sunday, December 16, 2018 10:17 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)

December 16, 2018 at 12:48 pm

#2016416
RE: Issue with midnight in stored procedure

Phil Parkin - Sunday, December 16, 2018 12:18 PM
Jeff Moden - Sunday, December 16, 2018 10:05 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)

December 16, 2018 at 12:46 pm

#2016415
RE: PERCENTILE_DISC for median calculation

So, in reference to your original question of...
Question: is PERCENTILE_DISC for median calculation works for both odd and even number of records?

...what is your conclusion?
--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)

December 16, 2018 at 11:57 am

#2016412

Viewing 15 posts - 10,351 through 10,365 (of 59,099 total)

Jeff Moden

Forum Replies Created

Return Types