Jeff Moden

Forum Replies Created

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

RE: GUIDs as clustered index

Sergiy - Wednesday, May 30, 2018 6:48 PM
Whatever kind of identity you choose to use - it's the worst possible choice for...
--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 31, 2018 at 8:32 am

#1992485
RE: GUIDs as clustered index

frederico_fonseca - Wednesday, May 30, 2018 6:23 PM
Jeff Moden - Wednesday, May 30, 2018 3:05 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 31, 2018 at 8:13 am

#1992478
RE: The SQL Joke Thread

😀
--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:29 pm

#1992409
RE: GUIDs as clustered index

vsamantha35 - Wednesday, May 30, 2018 3:14 PM
Hi Jeff,
Thanks for taking time and providing insights. thanks.
My recommendation is 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 30, 2018 at 3:28 pm

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

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