Jeff Moden

Forum Replies Created

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

RE: Finding a String Anywhere in Another String

hakan_l_borg - Wednesday, August 1, 2018 9:58 AM
Hi Luis, well the APS sure ships as a parallellism solution to query perf issues...
--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 3:47 pm

#2000086
RE: Time Outs!!

I guess I'd do two things before any of that substantial deep diving...
1. Rebuild stats or at least make sure they've been rebuilt.
2. Check the indexes being...
--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 3:30 pm

#2000084
RE: Finding a String Anywhere in Another String

Janeta Parakosova - Thursday, August 2, 2018 1:34 PM
Hi Jeff,
I used GUIDs to generate random strings with LEFT(NEWID(), 20) for the article....
--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 2:07 pm

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

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