Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,586 through 15,600 (of 59,101 total)

RE: Bad I/O on C: drive

Kevin3NF - Thursday, February 23, 2017 6:36 AM
Michelle-138172 - Monday, February 20, 2017 1:42 PM
...These...
--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 11:20 am

#1930009
RE: Use SQL to dedupe csv data

If it were me, I'd just import the file into a table, hit it with the SQL hammer, and convert the deduplicated data to XML, and export it.
--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 11:16 am

#1930008
RE: Data import files

The answer given is a bit of hooie if you consider that these QOTD questions are typically based on the latest version documented in BOL. It'll import properly structured CSV...
--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 11:03 am

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

Nah... I was doing some research and it popped up on the radar. Couldn't resist. 😉
--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 10:55 am

#1930002
RE: Performance improves after reboot

adb2303 - Thursday, February 23, 2017 9:45 AM
Have you got round to rebalancing those tempdb files yet?
I almost wouldn't bother with 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)

February 23, 2017 at 10:53 am

#1930001
RE: The Cloud is Just a Tool

mjh 45389 - Thursday, February 23, 2017 8:36 AM
Jeff Moden - Thursday, February 23, 2017 7:35 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 23, 2017 at 10:45 am

#1929999
RE: The Cloud is Just a Tool

Heh... based on the comments so far, I feel redeemed in my very low opinion of the "cloud". 😉
--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 7:35 am

#1929949
RE: SQL Server Trace Flags - Complete list

VERY useful. Thank you for taking the time to put it together.
On TF 8666... the description is a bit unremarkable as to what it can actually be used...
--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:45 am

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

Viewing 15 posts - 15,586 through 15,600 (of 59,101 total)