Jeff Moden

Forum Replies Created

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

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

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