Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,371 through 14,385 (of 59,101 total)

RE: Stalled Query?

alex.sqldba - Saturday, September 9, 2017 12:28 PM
Jeff, (and others),
I've not go to testing this yet but just had the thought: would...
--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)

September 9, 2017 at 4:13 pm

#1958851
RE: Newbie - simple Query Question - function

Recommend you use CHAR(4) instead of VARCHAR(4). Right sizing and using the right datatype is a good habit to get into. VARCHAR(4) actually takes 6 bytes (4 for data, 2...
--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)

September 9, 2017 at 10:14 am

#1958849
RE: Powershell SMO - LastBackupDate without Copy_only Backup

Satheesh E.P. - Saturday, September 9, 2017 8:07 AM
@jeff Moden
I need to restore 7 databases from 5 different production servers and restore...
--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)

September 9, 2017 at 9:40 am

#1958848
RE: Determine Monday of next month and Monday of next week

jcelko212 32090 - Friday, September 8, 2017 2:23 PM
I think you missed the point. Those were display formats, not internal storage...
--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)

September 8, 2017 at 9:56 pm

#1958832
RE: Determine Monday of next month and Monday of next week

ScottPletcher - Thursday, September 7, 2017 1:59 PM
jcelko212 32090 - Thursday, September 7, 2017 1:40 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)

September 8, 2017 at 8:59 pm

#1958829
RE: Convert this SQL Agent Job Step to Powershell

Why on earth do you want to convert it to PowerShell, which is really not much more than a CLI to begin with?
--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)

September 8, 2017 at 4:24 pm

#1958819
RE: Using Tools that Fit

Andy Warren - Friday, September 8, 2017 3:56 PM
I was just re-reading the replies and enjoying the diversity of perspectives. The comment...
--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)

September 8, 2017 at 4:21 pm

#1958818
RE: QUERY: GET SPACE USED/FREE in All Databases

usenet - Friday, September 8, 2017 10:06 AM
No, of course not. This information is part of my daily run of checks on...
--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)

September 8, 2017 at 3:00 pm

#1958810
RE: QUERY: GET SPACE USED/FREE in All Databases

usenet - Wednesday, April 5, 2017 9:01 AM
Jeff, i tend to disagree.
If you want to get the actual usage information (via fileproperty...
--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)

September 8, 2017 at 9:58 am

#1958753
RE: To automatically change the value of a column if a particular date time is reached

You're welcome but it's not just me. A lot of good people on this thread made similar suggestions.
--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)

September 8, 2017 at 9:48 am

#1958752
RE: Using Tools that Fit

I'm looking forward to having a couple/three large monitors at home (not so much at work... people shouldn't see what I'm doing). I'll work on one in the middle and...
--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)

September 8, 2017 at 9:46 am

#1958751
RE: Are the posted questions getting worse?

Chris Harshman - Friday, September 8, 2017 6:54 AM
Jeff Moden - Thursday, September 7, 2017 6:06 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)

September 8, 2017 at 9:43 am

#1958750
RE: Are the posted questions getting worse?

Grant Fritchey - Friday, September 8, 2017 5:32 AM
Fellow Threadizens!
Today is my last day of work before Red Gate makes me take...
--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)

September 8, 2017 at 9:36 am

#1958748
RE: Are the posted questions getting worse?

Tom_Hogan - Friday, September 8, 2017 9:01 AM
Lynn Pettis - Thursday, September 7, 2017 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)

September 8, 2017 at 9:33 am

#1958747
RE: Determine Monday of next month and Monday of next week

jcobb 20350 - Thursday, September 7, 2017 4:07 PM
Jeff Moden - Wednesday, September 6, 2017 4:19 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)

September 8, 2017 at 9:30 am

#1958745

Viewing 15 posts - 14,371 through 14,385 (of 59,101 total)