Jeff Moden

Forum Replies Created

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

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

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