Jeff Moden

Forum Replies Created

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

RE: Rebuilding Indexes very often is good?

simon.evans 66088 - Thursday, May 24, 2018 6:00 AM
Hi Jeff,
When and where will the presentation be, I'm very interested also, but...
--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 24, 2018 at 6:51 am

#1991772
RE: Using FORMAT() for Dates

Eirikur Eiriksson - Thursday, May 24, 2018 5:43 AM
Jeff Moden - Thursday, May 24, 2018 5:21 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 24, 2018 at 6:47 am

#1991771
RE: Testing new indexes

alex.palmer - Thursday, May 24, 2018 2:37 AM
Hi
I'm looking for ideas\opinions\experience when it comes to testing new indexes.
Previously I've been able 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 24, 2018 at 6:04 am

#1991767
RE: Using FORMAT() for Dates

Nice write-up but, even with the warnings, I'm reminded of people that justify poor programming techniques or functionality because of low row counts. It's a bit like teaching people how 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 24, 2018 at 5:21 am

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

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