Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,196 through 12,210 (of 59,099 total)

RE: GUIDs as clustered index

vsamantha35 - Thursday, May 31, 2018 10:22 PM
Jeff Moden - Thursday, May 31, 2018 11:31 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)

June 1, 2018 at 6:16 am

#1992616
RE: GUIDs as clustered index

@sam-3,
First and while I'm waiting for the other info I asked about, a couple of comments about the AMT.ItemVersions table... here's the list of columns you provided along with some...
--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 10:28 pm

#1992594
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Thursday, May 31, 2018 4:52 PM
The contractor has begun work and the upgrade of the forums...
--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 5:14 pm

#1992584
RE: YTD running balance including missing months

jcelko212 32090 - Thursday, May 31, 2018 1:10 PM
Jeff Moden - Tuesday, May 29, 2018 3:55 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 4:45 pm

#1992581
RE: YTD running balance including missing months

patrickmcginnis59 10839 - Thursday, May 31, 2018 2:43 PM
Jeff Moden - Thursday, May 31, 2018 11:44 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 31, 2018 at 4:30 pm

#1992579
RE: GUIDs as clustered index

ScottPletcher - Thursday, May 31, 2018 3:18 PM
Table types are generally common to some extent, even across industries. I think many...
--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 4:06 pm

#1992576
RE: GUIDs as clustered index

ScottPletcher - Thursday, May 31, 2018 12:16 PM
Jeff Moden - Thursday, May 31, 2018 12:07 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 3:06 pm

#1992566
RE: Are the posted questions getting worse?

frederico_fonseca - Thursday, May 31, 2018 4:00 AM
getting ride of them quite fast - just open one of them, report it 3...
--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 12:13 pm

#1992530
RE: GUIDs as clustered index

ScottPletcher - Thursday, May 31, 2018 11:45 AM
Overall db performance. Not obsessed with just page splits, but total I/O overall, including...
--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 12:07 pm

#1992529
RE: YTD running balance including missing months

jcelko212 32090 - Thursday, May 31, 2018 11:17 AM
Lynn Pettis - Tuesday, May 29, 2018 3:37 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 11:44 am

#1992521
RE: GUIDs as clustered index

vsamantha35 - Thursday, May 31, 2018 11:26 AM
Using SQL Server 2016 Service Pack 1. I ll try to get the output...
--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 11:31 am

#1992517
RE: GUIDs as clustered index

ScottPletcher - Thursday, May 31, 2018 9:58 AM
Again, I've seen only a handful of dbs where the best clustering was identity...
--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 11:29 am

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

mick burden - Thursday, May 31, 2018 12:22 AM
Hi Jeff, no issues as such. It's just nice to find various alternatives 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 31, 2018 at 9:38 am

#1992498
RE: GUIDs as clustered index

ScottPletcher - Thursday, May 31, 2018 9:18 AM
Jeff Moden - Thursday, May 31, 2018 8:32 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 31, 2018 at 9:33 am

#1992497
RE: GUIDs as clustered index

vsamantha35 - Thursday, May 31, 2018 2:15 AM
Jeff Moden - Wednesday, May 30, 2018 3: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 31, 2018 at 9:17 am

#1992495

Viewing 15 posts - 12,196 through 12,210 (of 59,099 total)