Jeff Moden

Forum Replies Created

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

RE: The Number that shouldn't be a number

PHYData DBA - Thursday, December 13, 2018 9:07 AM
Eric M Russell - Thursday, December 13, 2018 7:47...
--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:06 pm

#2016615
RE: Monthly Report

CoryC - Monday, December 17, 2018 10:08 AM
I need to produce a monthly report on usage, uptime, and capacity. Any ideas on...
--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:32 pm

#2016612
RE: Find Next payment Date

ramrajan - Monday, December 10, 2018 6:38 PM
I have below table with columns date and Number of Payments and Next Payment Date...
--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:25 pm

#2016611
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

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