Jeff Moden

Forum Replies Created

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

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

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