Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,336 through 10,350 (of 59,099 total)

RE: PERCENTILE_DISC for median calculation

The OP actually made the mistake of posting their question in two separate posts. This question has been beat to death in the other post, which is located at 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)

December 17, 2018 at 5:20 pm

#2016610
RE: PIVOT operator is not allowed in the recursive part of a recursive common table expression

msimone - Monday, December 10, 2018 8:56 AM
Hello, i have a little problem.
I create an in lined table function and with SQL...
--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 5:16 pm

#2016609
RE: Where did our 30GBs go?

Here's what I think is the troublemaker for you...
[COMMENT] [varchar](7000) NULL,
Large comments like 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)

December 17, 2018 at 4:52 pm

#2016608
RE: PERCENTILE_DISC for median calculation

valeryk2000 - Monday, December 17, 2018 12:28 PM
Tried Offset/Fetch - works slower than Percentile ...
Do you have the correct index in place 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 17, 2018 at 3:48 pm

#2016602
RE: Issue with midnight in stored procedure

crmitchell - Monday, December 17, 2018 10:21 AM
scottmildenberger - Monday, December 17, 2018 8: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 17, 2018 at 3:45 pm

#2016601
RE: Do recruiters primarily recruit for contract jobs?

Rod at work - Monday, December 17, 2018 8:48 AM
Thinking about what you said, Jeff, I believe you're right. There's a lot...
--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 9:30 am

#2016533
RE: PERCENTILE_DISC for median calculation

Shirting gears back to my previous thoughts, I'm not sure why we're even talking about the PERCENTILE_* functions. They're a hundred times slower than Peter Larsson's method of using OFFSET/FETCH. ...
--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 8:50 am

#2016527
RE: PERCENTILE_DISC for median calculation

valeryk2000 - Monday, December 17, 2018 8:24 AM
NaÃ¯ve question. In the original line of my associate (she's testing our SS 2008 codes...
--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 8:46 am

#2016524
RE: CREATE EXTERNAL DATA SOURCE

GilaMonster - Monday, December 17, 2018 8:30 AM
It has both, at least according to the docs. Don't have a SQLDB on hand...
--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 8:41 am

#2016521
RE: Are the posted questions getting worse?

xsevensinzx - Sunday, December 16, 2018 5:00 PM
Jeff Moden - Sunday, December 16, 2018 3:53 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 17, 2018 at 8:38 am

#2016520
RE: problem with restore a backup in sql 2000. help me

After you finally do get your restore to work, then you really need to look at your backup plan with the idea of quickly doing restores in the future. Putting...
--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 8:29 am

#2016518
RE: The Wild Developers of SQL Server like Wildcards

Phil Factor - Monday, December 17, 2018 2:29 AM
Ah. Don't get me started about Format() and String-split(). It was just the poor...
--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 8:25 am

#2016517
RE: delete records in batches?? and recursive for tables

s.ravisankar - Monday, December 17, 2018 5:06 AM
Hi All
Thanks for your reply
I have checked with direct query then its not increasing log
If...
--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 8:13 am

#2016515
RE: Issue with midnight in stored procedure

lucaskhall - Monday, December 17, 2018 5:32 AM
In response to your concerns regarding how time is handled in this case our back...
--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 8:07 am

#2016513
RE: Where did our 30GBs go?

scarr030 - Monday, December 17, 2018 7:10 AM
Jonathan AC Roberts - Monday, December 17, 2018 6:45 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 17, 2018 at 8:00 am

#2016510

Viewing 15 posts - 10,336 through 10,350 (of 59,099 total)