Jeff Moden

Forum Replies Created

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

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
RE: How to find the first recurring character of a string.

I think that maybe looking at the 2nd character of a two character match may make optimization of all this a bit easier.

DECLARE @str...
--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:27 pm

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

Stan Kulp-439977 - Monday, October 30, 2017 1:29 PM
I had to deal with data containing a field with multiple values. It wasn't...
--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 3:44 pm

#1965868
RE: Substring Question

Alan.B - Monday, October 30, 2017 2:02 PM
Another way, using Luis' sample data
SELECT name, rtrim(ltrim(isnull(parsename(' '+x.name+' ', 2), x.name))) 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 30, 2017 at 2:59 pm

#1965864
RE: StartDate and EndDate in same column

jcelko212 32090 - Monday, October 30, 2017 12:21 PM
Redmond01 - Thursday, October 26, 2017 5:54 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 30, 2017 at 12:36 pm

#1965840
RE: What else can take up space in a database besides tables

Sue_H - Monday, October 30, 2017 11:21 AM
Jeff Moden - Monday, October 30, 2017 8:59 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 30, 2017 at 12:33 pm

#1965839
RE: SAN high availability in cluster

ALZDBA - Monday, October 30, 2017 8:09 AM
A single SAN is such a liability ( and still have a risk of going...
--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 12:29 pm

#1965836

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