Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,406 through 15,420 (of 59,063 total)

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
RE: Use date and time in sql statement for join, but not required in the output

jcelko212 32090 - Friday, March 10, 2017 2:26 PM
Jeff Moden - Monday, March 6, 2017 8: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)

March 11, 2017 at 7:28 am

#1932813
RE: Need SQL query to get hierarchical structure of Employees

acmedeepak - Thursday, March 9, 2017 9:19 AM
I have a table with two columns:
Employee, Superior with their names in it.
Now, 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 10, 2017 at 6:50 pm

#1932807
RE: SQL Server 2016 DBA Training

Thanks, Daniel. I'll look into it.
--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 10, 2017 at 10:49 am

#1932770
RE: How to overcome the identity column "jump 1000" issue

Sean Lange - Friday, March 10, 2017 9:13 AM
ScottPletcher - Friday, March 10, 2017 9:02 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 10, 2017 at 10:44 am

#1932769

Viewing 15 posts - 15,406 through 15,420 (of 59,063 total)