Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,241 through 12,255 (of 59,095 total)

RE: A Great Case for Powershell

Frank W Fulton Jr - Wednesday, May 23, 2018 3:42 PM
Jeff Moden - Tuesday, May 22, 2018...
--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)

May 23, 2018 at 8:33 pm

#1991736
RE: detect if previous record is higher or lower ?

David Burrows - Wednesday, May 23, 2018 7:24 AM
Jeff Moden - Wednesday, May 23, 2018 6:38 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)

May 23, 2018 at 7:47 am

#1991616
RE: Cursors

varunchopra.apj - Wednesday, May 23, 2018 7:07 AM
Hi Guys,
I also used cursor in the recent situation where I need to fire dynamic...
--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)

May 23, 2018 at 7:23 am

#1991606
RE: Pause and Backtrack

David.Poole - Wednesday, May 23, 2018 1:49 AM
For me its a case of "with great power comes great responsibility".
I have been having...
--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)

May 23, 2018 at 6:59 am

#1991599
RE: detect if previous record is higher or lower ?

mick burden - Wednesday, May 23, 2018 2:29 AM
Thanks David, that's a great help. I don't suppose you know what Jeff means...
--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)

May 23, 2018 at 6:38 am

#1991595
RE: Cursors

paul s-306273 - Wednesday, May 23, 2018 1:38 AM
Thanks for posting that Jeff. This is almost certainly going to lead 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)

May 23, 2018 at 5:51 am

#1991588
RE: A Great Case for Powershell

xsevensinzx - Wednesday, May 23, 2018 5:29 AM
Yeah, not seeing command line dying on any OS. Those who are always tied 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)

May 23, 2018 at 5:43 am

#1991586
RE: Restoring database A also tries to Restore database B

Mr J - Tuesday, May 22, 2018 7:50 PM
Success!!
Thanks E4D4 and John... when I restored the new db without the tail log...
--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)

May 22, 2018 at 9:44 pm

#1991546
RE: Best way to move database data files to the same size

nsunderman - Tuesday, May 22, 2018 3:40 PM
I have inherited an approximately 800GB SQL 2016 database (recently migrated) with 35 data files...
--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)

May 22, 2018 at 9:42 pm

#1991545
RE: Pause and Backtrack

To be honest, even though both options are great for what they do, they both suck at what actually needs to be done. That would be to backtrack through the...
--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)

May 22, 2018 at 9:38 pm

#1991544
RE: detect if previous record is higher or lower ?

mick burden - Tuesday, May 22, 2018 7:51 PM
In it's simplest form if I had a table that stored a persons name,...
--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)

May 22, 2018 at 9:34 pm

#1991543
RE: Returning @@IDENTITY from an OPENQUERY INSERT Statement

dotnet85 - Tuesday, May 22, 2018 7:51 PM
any update on the topic? I am facing the same issue.
Thank you
I don't know what...
--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)

May 22, 2018 at 9:30 pm

#1991542
RE: How do I hand my Stored Procedure A String List

I've not worked with VB in more than a decade so I'm a bit rusty there. It looks like you're trying to send a quoted CSV and then split 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)

May 22, 2018 at 9:27 pm

#1991541
RE: Cursors

Lynn Pettis - Tuesday, May 22, 2018 1:07 PM
jcelko212 32090 - Tuesday, May 22, 2018 12:59 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)

May 22, 2018 at 9:19 pm

#1991540
RE: Cursors

ZZartin - Friday, May 18, 2018 10:37 AM
There are some tasks that can only be accomplished with cursors, for example loop through...
--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)

May 22, 2018 at 9:13 pm

#1991538

Viewing 15 posts - 12,241 through 12,255 (of 59,095 total)