Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,436 through 15,450 (of 59,097 total)

RE: Encapsulating complex logic without using a scalar UDF

jcelko212 32090 - Tuesday, March 14, 2017 2:04 PM
Jeff Moden - Tuesday, March 14, 2017 11:25 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)

March 15, 2017 at 6:23 pm

#1933387
RE: Encapsulating complex logic without using a scalar UDF

The single update on a calendar table to renumber the working day enumerations is a no brainer, folks. And, like anything else, it needs to be written correctly. It's not...
--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)

March 15, 2017 at 6:21 pm

#1933386
RE: 'Spell check' a string-valued field

First, apologies for thinking it was XML. Jason is correct. I got the word "tags" and the <somestring> format stuck in my head. Shifting gears to your problem...
Try...
--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)

March 14, 2017 at 10:05 pm

#1933171
RE: Clustered scan vs Non-clustered Seek with lookup

ScottPletcher - Tuesday, March 14, 2017 4:35 PM
Jeff Moden - Tuesday, March 14, 2017 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)

March 14, 2017 at 7:59 pm

#1933167
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Ah... you're absolutely correct. I should have listed it as just En or the more formal 1En or the spreadsheet notation of 10^n. Thank you.
--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)

March 14, 2017 at 11:42 am

#1933106
RE: Clustered scan vs Non-clustered Seek with lookup

I'd make sure that col1 is immutable, unique, and ever-increasing or there will be performance hell to pay on inserts and updates.
--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)

March 14, 2017 at 11:32 am

#1933103
RE: 'Spell check' a string-valued field

There is, however, a way to do this. I forget the exact code but if you open up XML as an XML Document, you can easily derive all of 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)

March 14, 2017 at 11:27 am

#1933100
RE: Encapsulating complex logic without using a scalar UDF

Yep, agreed. I've actually done similar to what Joe suggests for the work day thing. I have two columns with a "work day" enumeration... one where the weekend days (for example)...
--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)

March 14, 2017 at 11:25 am

#1933099
RE: 'Spell check' a string-valued field

Heh... spell checking tags. There's another good reason to avoid XML if I ever heard one. 😉
--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)

March 14, 2017 at 11:02 am

#1933092
RE: Encapsulating complex logic without using a scalar UDF

bmg002 - Tuesday, March 14, 2017 9:47 AM
Jeff, that makes sense then. I had it set to results to grid, so I...
--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)

March 14, 2017 at 10:58 am

#1933090
RE: Encapsulating complex logic without using a scalar UDF

bmg002 - Monday, March 13, 2017 4:27 PM
Jeff Moden - Monday, March 13, 2017 3:50 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)

March 14, 2017 at 5:32 am

#1933009
RE: Find out consecutive date difference by comparing with master table

jcelko212 32090 - Monday, March 13, 2017 10:24 AM
You also got the display format for dates wrong; the only format allowed in...
--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)

March 13, 2017 at 4:10 pm

#1932969
RE: Encapsulating complex logic without using a scalar UDF

jcelko212 32090 - Monday, March 13, 2017 11:17 AM
Jeff Moden - Saturday, March 11, 2017 8:42 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)

March 13, 2017 at 3:50 pm

#1932965
RE: Need Correct Index for slow query

Do NOT convert your TEXT columns to NVARCHAR(MAX). It's a waste of disk space, memory, and IO because NVARCHAR uses two characters per byte instead of just one. You would...
--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)

March 12, 2017 at 11:56 am

#1932841
RE: Encapsulating complex logic without using a scalar UDF

jcelko212 32090 - Thursday, March 9, 2017 3:35 PM
You are treating a UDF the way you would have written code in COBOL,...
--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)

March 11, 2017 at 8:42 pm

#1932821

Viewing 15 posts - 15,436 through 15,450 (of 59,097 total)