Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,386 through 14,400 (of 59,097 total)

RE: Powershell SMO - LastBackupDate without Copy_only Backup

I guess I don't understand why you're using PowerShell to do 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)

September 7, 2017 at 8:28 pm

#1958666
RE: Using Tools that Fit

Heh... "I'm workin' for a livin' so I'm takin' what they're givin'". 🙂 Except for the chair... I stole a good one from a conference room when the company moved...
--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 7, 2017 at 8:00 pm

#1958662
RE: Are the posted questions getting worse?

Lynn Pettis - Thursday, September 7, 2017 3:53 PM
Where is the petition to ban JC?
Nah... don't ban him. He needs to 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 7, 2017 at 6:06 pm

#1958660
RE: Are the posted questions getting worse?

Lynn Pettis - Thursday, September 7, 2017 3:10 PM
Chris Harshman - Thursday, September 7, 2017 3:04 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 7, 2017 at 6:04 pm

#1958659
RE: Stalled Query?

Thanks for the feedback. There's a whole lot more to all of this, especially concerning minimal logging and TF610. Although the document is quite old (written for SL Server 2008),...
--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 7, 2017 at 5:58 pm

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

jcelko212 32090 - Thursday, September 7, 2017 2:11 PM
Ed Wagner - Tuesday, September 5, 2017 2:16 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 7, 2017 at 5:53 pm

#1958657
RE: huge diffence direct query vs query view

ALZDBA - Thursday, September 7, 2017 1:16 AM
Jeff Moden - Wednesday, September 6, 2017 1:31 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 7, 2017 at 11:40 am

#1958620
RE: Stalled Query?

frederico_fonseca - Thursday, September 7, 2017 2:24 AM
From my own experience on doing these type of changes my advise is to create...
--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 7, 2017 at 11:31 am

#1958619
RE: Stalled Query?

alex.sqldba - Thursday, September 7, 2017 12:55 AM
This table resides on a single filegroup.
PERFECT! This is going to be easy and relatively...
--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 7, 2017 at 11:30 am

#1958618
RE: PLE

Arsh - Friday, September 1, 2017 3:41 AM
Jeff Moden - Thursday, August 31, 2017 2: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 6, 2017 at 9:08 pm

#1958479
RE: Not at all, but we almost upset

Looks like the data wasn't the only thing that disappeared. The OP has now gone missing.
--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 6, 2017 at 8:49 pm

#1958478
RE: If you weren't a DBA, what would you be doing?

Heh... it's funny. If you look back at all the alternatives that folks have listed, a DBA pretty much has to have all those skills combined.
--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 6, 2017 at 8:45 pm

#1958477
RE: JOIN Question

Thom A - Tuesday, September 5, 2017 2:48 AM
When you want to return data from another table, but retain rows if there...
--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 6, 2017 at 8:42 pm

#1958475
RE: Independence Day

Ed Wagner - Wednesday, July 5, 2017 6:56 PM
TomThomson - Tuesday, July 4, 2017 3:20 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)

September 6, 2017 at 8:23 pm

#1958474
RE: Independence Day

TomThomson - Tuesday, July 4, 2017 3:20 AM
The use of "dw" fooled me - I thought that would either result in a...
--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 6, 2017 at 8:17 pm

#1958472

Viewing 15 posts - 14,386 through 14,400 (of 59,097 total)