Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,876 through 13,890 (of 59,101 total)

RE: StartDate and EndDate in same column

@joe,
While I agree that you can not depend on some "natural" order in a table, that has nothing to do with storing something in the table 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)

October 31, 2017 at 3:48 pm

#1966080
RE: latest timestamp multiple databases

patrickmcginnis59 10839 - Friday, October 20, 2017 1:05 PM
Jeff Moden - Tuesday, October 17, 2017 8:06 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)

October 31, 2017 at 9:44 am

#1966004
RE: Fun Data Arithmetic

GD_515 - Tuesday, October 31, 2017 9:20 AM
Jeff Moden - Tuesday, October 31, 2017 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)

October 31, 2017 at 9:39 am

#1966001
RE: How to find the first recurring character of a string.

David Burrows - Tuesday, October 31, 2017 9:16 AM

WITH cte AS (
SELECT t.N,SUBSTRING(@Str,N,1) AS [C],
ROW_NUMBER() OVER (PARTITION BY SUBSTRING(@Str,N,1) ORDER BY...
--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)

October 31, 2017 at 9:33 am

#1966000
RE: Minimal Logging

hello mahesh - Tuesday, October 31, 2017 8:34 AM
Jeff Moden - Tuesday, October 31, 2017 8:27 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)

October 31, 2017 at 9:02 am

#1965992
RE: Fun Data Arithmetic

GD_515 - Tuesday, October 31, 2017 2:10 AM
ildjarn.is.dead - Tuesday, October 31, 2017 1:12 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)

October 31, 2017 at 8:54 am

#1965990
RE: Fun Data Arithmetic

ildjarn.is.dead - Tuesday, October 31, 2017 1:12 AM
I think it stores the dates as floats, not ints.
I used to think so as...
--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)

October 31, 2017 at 8:51 am

#1965988
RE: Minimal Logging

hello mahesh - Monday, October 30, 2017 7:44 PM
"(3) Depending on the plan chosen by the optimizer, the nonclustered index on 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)

October 31, 2017 at 8:27 am

#1965980
RE: PURGING DATA

So you want to delete from your date dimension table on a regular basis??? :blink:
--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)

October 31, 2017 at 8:24 am

#1965977
RE: Join on a Substring

I guess my take on it would be to brow beat someone into letting me add a persisted, indexed, computed column based on the integer datatype. No matter what else...
--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)

October 31, 2017 at 8:18 am

#1965974
RE: SQL versus program

rot-717018 - Tuesday, October 31, 2017 2:55 AM
patrickmcginnis59 10839 - Monday, October 30, 2017 10:56 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)

October 31, 2017 at 8:09 am

#1965971
RE: How to find the first recurring character of a string.

TheCTEGuy - Tuesday, October 31, 2017 1:32 AM
Jeff Moden - Monday, October 30, 2017 4:27 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)

October 31, 2017 at 8:02 am

#1965966
RE: Which is the end?

Ed Wagner - Tuesday, October 31, 2017 5:40 AM
Jeff Moden - Monday, October 30, 2017 4:31 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)

October 31, 2017 at 7:59 am

#1965965
RE: Parse Data from a Field Containing Multiple Values using CROSS APPLY

corey lawson - Monday, October 30, 2017 8:04 PM
vl1969-734655 - Monday, October 30, 2017 5: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)

October 31, 2017 at 7:57 am

#1965964
RE: Which is the end?

Ed Wagner - Monday, October 30, 2017 6:32 AM
It's a nice function that fills a hole, but one I've always used 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)

October 30, 2017 at 4:31 pm

#1965870

Viewing 15 posts - 13,876 through 13,890 (of 59,101 total)