Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,686 through 11,700 (of 59,099 total)

RE: Foreign Keys

Grant Fritchey - Thursday, August 2, 2018 9:02 AM
Jeff Moden - Thursday, August 2, 2018 8:54 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)

August 2, 2018 at 1:20 pm

#2000066
RE: Variable assignments

lmalatesta - Thursday, August 2, 2018 11:03 AM
Jeff Moden - Monday, July 23, 2018 1:46 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)

August 2, 2018 at 1:17 pm

#2000063
RE: Finding a String Anywhere in Another String

Jeff Moden - Tuesday, July 31, 2018 12:09 PM
Janeta Parakosova - Tuesday, July 31, 2018 11:03 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)

August 2, 2018 at 1:10 pm

#2000061
RE: Finding a String Anywhere in Another String

hakan_l_borg - Thursday, August 2, 2018 12:09 AM
Thats not what I said either.
Understood but a whole lot of people take it 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)

August 2, 2018 at 9:02 am

#2000011
RE: Foreign Keys

Grant Fritchey - Thursday, August 2, 2018 5:02 AM
So a little confusion here. Foreign keys should be bound to unique constraints/unique indexes....
--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)

August 2, 2018 at 8:54 am

#2000009
RE: Finding levels in a hierarchy

vee van gelder - Wednesday, August 1, 2018 1:27 AM
you kinda of making assumptions about what is needed for the POC,...
--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)

August 2, 2018 at 8:07 am

#2000002
RE: Finding a String Anywhere in Another String

Janeta Parakosova - Tuesday, July 31, 2018 11:03 AM
@luis, I was unaware of Aaron's post and I could not find anything similar...
--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)

July 31, 2018 at 12:09 pm

#1999742
RE: Finding levels in a hierarchy

I've found that doing things right in the POC phase is critical rather than a luxury. 😀 If you don't get things right during the POC, you might miss out...
--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)

July 31, 2018 at 11:57 am

#1999738
RE: Are the posted questions getting worse?

WayneS - Tuesday, July 31, 2018 8:18 AM
Ed Wagner - Monday, July 30, 2018 11: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)

July 31, 2018 at 8:53 am

#1999696
RE: Finding levels in a hierarchy

vee van gelder - Tuesday, July 31, 2018 8:42 AM
hi everyone, thanks so much for all your helpful responses, ive played around...
--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)

July 31, 2018 at 8:50 am

#1999693
RE: Finding levels in a hierarchy

vee van gelder - Monday, July 30, 2018 2:06 AM
i have some data which has a variable amount of hiearchy levels 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)

July 30, 2018 at 7:37 am

#1999468
RE: Changing table name used in function, stored procedure and views

laurie-789651 - Monday, July 30, 2018 7:12 AM
The danger there is losing the use of indexes, especially in joins, & getting a...
--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)

July 30, 2018 at 7:34 am

#1999466
RE: Changing table name used in function, stored procedure and views

If the VIEWS are created correctly, they they'll use the underlying indexes, etc, of the tables just fine.
I do agree with the others that the use...
--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)

July 30, 2018 at 7:32 am

#1999464
RE: Get 2 decimals in my query

GG_BI_GG - Tuesday, July 24, 2018 12:50 AM
SELECT 'Per Category' AS Category,
[1], [2], [3], [4], [5], [6], [7], [8]
FROM ...
--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)

July 28, 2018 at 5:46 am

#1999348
RE: Get 2 decimals in my query

andycadley - Wednesday, July 25, 2018 12:34 PM
DDL will definitely help people to help you. You might want to investigate the FORMAT...
--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)

July 28, 2018 at 5:42 am

#1999347

Viewing 15 posts - 11,686 through 11,700 (of 59,099 total)