Jeff Moden

Forum Replies Created

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

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
RE: Automate daily table backup

Ah... yeah. Agreed.
Unfortunately, it looks like the OP has flown the coop.
--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 27, 2018 at 7:39 pm

#1999333
RE: SQL/DBA freelance work

Let's see... you've posted no references, no links, no resume, you joined this site 9 years ago, made exactly one reply post, and now you expect this site to be...
--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 27, 2018 at 9:28 am

#1999260
RE: Speeding Up Incremental ETL Proceses in SSIS by Using MD5 Hashes

sabyasm - Thursday, September 2, 2010 10:22 AM
[font="Comic Sans MS"]This is an excellent article.However - I am facing a peculier problem that...
--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 27, 2018 at 7:50 am

#1999241
RE: How to pass and use Variable on CTE

luissantos - Friday, July 27, 2018 7:14 AM
Hello,
Thanks for all your replies , i will go create function to split values.
Many thanks
LS
I'll...
--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 27, 2018 at 7:46 am

#1999240

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