Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,601 through 15,615 (of 59,097 total)

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
RE: High Disk Queue length

Admingod - Tuesday, February 14, 2017 10:49 AM
The SQL Server version is 2014. Its on same SAN before and After. Moved 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)

February 17, 2017 at 10:48 pm

#1929230
RE: IO Performance Problem

Haven't checked to see what the others have said but do you , by any chance, have automatic updates or automatic downloads turned on in Windows or your anti-virus software? ...
--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 10:41 pm

#1929229
RE: Turning Cols into Rows

rjjh78 - Friday, February 17, 2017 2:18 PM
Hi Steve, Thank you for your...
--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 9:55 pm

#1929228
RE: Convert first column in row without duplicate values, and second column in rows

benkraiemchedlia - Friday, February 17, 2017 9:39 AM
Y.B. - Friday, February 17, 2017 7:53 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 17, 2017 at 8:51 pm

#1929225
RE: Convert first column in row without duplicate values, and second column in rows

Luis Cazares - Friday, February 17, 2017 5:44 AM
benkraiemchedlia - Friday, February 17, 2017 12:31 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 17, 2017 at 8:39 pm

#1929224
RE: Convert first column in row without duplicate values, and second column in rows

Y.B. - Thursday, February 16, 2017 1:18 PM
A simple crosstab will do. You will need to use dynamic SQL if you want...
--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 8:35 pm

#1929223
RE: Convert first column in row without duplicate values, and second column in rows

benkraiemchedlia - Friday, February 17, 2017 12:31 AM
Jeff Moden - Thursday, February 16, 2017 10:39 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 17, 2017 at 8:32 pm

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

frederico_fonseca - Friday, February 17, 2017 5:02 PM
Jeff Moden - Friday, February 17, 2017 4:29 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 17, 2017 at 5:45 pm

#1929221
RE: Trouble with openxml query

Sergiy - Friday, February 17, 2017 1:31 PM
Jeff Moden - Thursday, February 16, 2017 6:26 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 17, 2017 at 4:51 pm

#1929219
RE: Trouble with openxml query

patrickmcginnis59 10839 - Friday, February 17, 2017 7:23 AM
So are you telling me that you are jumping the OP for practices...
--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 4:41 pm

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

frederico_fonseca - Friday, February 17, 2017 3:56 PM
Really really depends on the volumes you are going to be loading, how many times...
--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 4:29 pm

#1929216

Viewing 15 posts - 15,601 through 15,615 (of 59,097 total)