Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,556 through 15,570 (of 59,063 total)

RE: BCP via batch file - Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file

rob_nye - Thursday, February 23, 2017 2:11 AM
turns out the problem was the date field on each row.. wasnt being recognised as...
--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)

February 23, 2017 at 5:43 am

#1929915
RE: The Cloud is Just a Tool

Definitely 5 stars on this one, Steve. Very well done!
--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)

February 23, 2017 at 5:39 am

#1929913
RE: What is RBAR? How can I avoid it?

Heh... must've got stuck in a loop somewhere. 😉
--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)

February 22, 2017 at 9:51 pm

#1929887
RE: Performance improves after reboot

RVO - Wednesday, February 22, 2017 9:30 AM
Jeff,
Agree. I already monitoring the content of TEMPDB and try to identify the biggest performance...
--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)

February 22, 2017 at 8:37 pm

#1929885
RE: Performance improves after reboot

Sue_H - Wednesday, February 22, 2017 12:35 PM
cphite - Wednesday, February 22, 2017 12:09 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)

February 22, 2017 at 8:07 pm

#1929884
RE: Restore DB takes a coffee break to open file explorer

royce.bacon - Wednesday, February 22, 2017 8:13 AM
A lot times the reason for slow file browses is that there is a mapped...
--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)

February 22, 2017 at 4:36 pm

#1929872
RE: transpose like function

sgmunson - Wednesday, February 22, 2017 7:38 AM
Jeff Moden - Wednesday, February 22, 2017 7:30 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)

February 22, 2017 at 8:43 am

#1929748
RE: Performance improves after reboot

RVO - Wednesday, February 22, 2017 8:01 AM
Performance did not get substantially worse yet since last reboot on January 29th.
My guess one...
--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)

February 22, 2017 at 8:16 am

#1929739
RE: Restore Recovered Database ?!! Please Help!!!!!

Sue_H - Wednesday, February 22, 2017 7:57 AM
Jeff Moden - Wednesday, February 22, 2017 7: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)

February 22, 2017 at 8:04 am

#1929732
RE: Restore Recovered Database ?!! Please Help!!!!!

my Database set as UTF-8
I'm curious what is meant by that. I didn't know there was such a setting. To those that know, is this...
--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)

February 22, 2017 at 7:45 am

#1929723
RE: transpose like function

OJDev - Wednesday, February 22, 2017 6:59 AM
Thank you. Would there also be a way in which I don't have to specify...
--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)

February 22, 2017 at 7:30 am

#1929713
RE: Good or slow? 1 min to load 600M text format into SQL

Sounds really interesting. You should do an article here on SSC on what you've done. I'm thinking that it would be a smash hit.
--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)

February 18, 2017 at 10:56 am

#1929245
RE: t-sql 2012 rank or priortize values in one column

You've been here long enough to know what it takes to get a "show me what it takes" answer, Wendy. Readily consumable test data. Please see the following. Thanks for...
--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)

February 17, 2017 at 11:22 pm

#1929233
RE: Retiring from one team and onwards

Heh... I'm only working half-time compared to my previous job... of 80 to 90 hours a week. I would love a "boring" job for a change.
--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)

February 17, 2017 at 11:20 pm

#1929232
RE: Check if xp_cmdshell is turned on and flip the bit

Actually, I had previously uploaded the presentation to this site. You can find it at the following URL. Hard to believe I first did this one almost 4 years ago.
--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)

February 17, 2017 at 11:10 pm

#1929231

Viewing 15 posts - 15,556 through 15,570 (of 59,063 total)