Jeff Moden

Forum Replies Created

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

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
RE: need 3rd day of Calendar month - date precision to exclude minutes

For more info on DATEPART, please see the article at the following link.
https://docs.microsoft.com/en-us/sql/t-sql/functions/datepart-transact-sql?view=sql-server-2017
There's also a wealth of knowledge just a click away in the menu...
--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:48 am

#2016411
RE: need 3rd day of Calendar month - date precision to exclude minutes

polkadot - Sunday, December 16, 2018 11:14 AM
I need query (in my case an INSERT) to run only if today's date is...
--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:26 am

#2016410
RE: Email results of Failed Jobs

Why wouldn't you use an INSERT/SELECT into a table and create the email from those results?
--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 10:39 am

#2016408
RE: CREATE EXTERNAL DATA SOURCE

I'm not an Azure user by any means so be gentle, please... Azure doesn't have a BULK INSERT command or OPENROWSET? :blink:
--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 10:36 am

#2016407

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

Jeff Moden

Forum Replies Created

Return Types