Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,211 through 12,225 (of 59,095 total)

RE: The SQL Joke Thread

sgmunson - Wednesday, May 30, 2018 3:12 PM
Jeff Moden - Friday, May 18, 2018 1:28 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 30, 2018 at 3:14 pm

#1992404
RE: GUIDs as clustered index

p.s. While I hate the use of GUIDs (I simply don't like looking at them or typing them) and totally contrary to popular belief, it's actually quite easy to manage...
--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 30, 2018 at 3:05 pm

#1992400
RE: GUIDs as clustered index

vsamantha35 - Wednesday, May 30, 2018 5:43 AM
Hi All,
Looking for some suggestions.
Currently, In our system we have GUIDs are primary...
--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 30, 2018 at 3:01 pm

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

@Mick,
Are you all set or do you still have issues with this problem?
--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 30, 2018 at 2:45 pm

#1992395
RE: Aggravate and archive raw data tables

saptek9 - Tuesday, May 29, 2018 2:30 PM
Please suggest me next steps i have to do.
Post more information so we can actually...
--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 29, 2018 at 6:17 pm

#1992247
RE: Query newbie question

adamwgrise - Tuesday, May 29, 2018 12:43 PM
sgmunson - Friday, May 25, 2018 8:26 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 29, 2018 at 4:12 pm

#1992245
RE: YTD running balance including missing months

Lynn Pettis - Tuesday, May 29, 2018 3:37 PM
jcelko212 32090 - Tuesday, May 29, 2018 12:24 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 29, 2018 at 3:55 pm

#1992241
RE: YTD running balance including missing months

sgmunson - Tuesday, May 29, 2018 10:25 AM
ddly_ann - Monday, May 28, 2018 7:47 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 29, 2018 at 3:39 pm

#1992237
RE: Rebuilding Indexes very often is good?

pdanes - Tuesday, May 29, 2018 2:49 AM
I'm also looking forward to reading the article, but from the graph, it looks like...
--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 29, 2018 at 6:14 am

#1992155
RE: by what size will nvarchar(max) column get stored in LOB_DATA allocation unit?

Marek Grzymala - Saturday, May 26, 2018 9:42 AM
I have a table defined as follows:
CREATE TABLETABLE [TestTable] [TestTable]
((
Col1 ...
--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 27, 2018 at 10:09 am

#1992074
RE: copy data from one table to another table same structure

Eirikur Eiriksson - Saturday, May 26, 2018 1:35 AM
montserrat.deza - Friday, May 25, 2018 6:02 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 27, 2018 at 9:51 am

#1992073
RE: Using FORMAT() for Dates

Yes he did. I've acknowledged that in my posts a couple of times now and is a part of what we're discussing.
--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 26, 2018 at 3:30 pm

#1992062
RE: sql graph query output

Not trying to be difficult here. I'm trying to anticipate your next question after this. 😉
What will you do with the output you require once someone has shown...
--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 26, 2018 at 11:22 am

#1992058
RE: Using FORMAT() for Dates

patrickmcginnis59 10839 - Friday, May 25, 2018 9:59 AM
Jeff Moden - Friday, May 25, 2018 8:35 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 26, 2018 at 12:25 am

#1992045
RE: Using FORMAT() for Dates

Steve Jones - SSC Editor - Thursday, May 24, 2018 4:31 PM
Jeff Moden - Thursday, May 24,...
--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 25, 2018 at 10:42 pm

#1992044

Viewing 15 posts - 12,211 through 12,225 (of 59,095 total)