Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,651 through 10,665 (of 59,099 total)

RE: Julian Date

Thanks, Frederico. Time for some play.
--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)

November 10, 2018 at 11:30 am

#2013088
RE: Julian Date

Can we see the code you used to generate the test data? My concern is that it may have a cardinality of "1" and that can lead to some pretty...
--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)

November 10, 2018 at 10:48 am

#2013086
RE: The Cost of Switching

Back to the subject of "switching", I've found that there are several hidden costs to making such switches. The single greatest loss (IMHO) is "Lost Learning" and the "art" of...
--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)

November 10, 2018 at 10:04 am

#2013082
RE: Julian Date

frederico_fonseca - Saturday, November 10, 2018 9:31 AM
one other option (and there are more)
declare @tbl table
( juldate decimal(18, 0)
...
--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)

November 10, 2018 at 9:53 am

#2013080
RE: Are the posted questions getting worse?

Lynn Pettis - Wednesday, October 31, 2018 2:52 PM
Grant Fritchey - Wednesday, October 31, 2018 2:36 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)

November 10, 2018 at 9:40 am

#2013079
RE: Julian Date

p.s. If you don't understand the code and how it does what it does, post back. You're the one that will have to support the code.
--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)

November 10, 2018 at 9:27 am

#2013077
RE: Julian Date

This should do it for you

--===== Create a sample using variables.
DECLARE @OrderDate NUMERIC(18,0) = 118063
,@OrderTime FLOAT = 11456
;
--===== This solves for...
--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)

November 10, 2018 at 9:23 am

#2013076
RE: Julian Date

K. I'm on it. Back in a few.
--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)

November 10, 2018 at 9:13 am

#2013075
RE: Julian Date

irehman - Saturday, November 10, 2018 8:41 AM
@jeff Moden
OrderDate: Sample Data: 118063 and data type is Numeric (18,0)
OrderTime: Sample Data: 11456 and...
--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)

November 10, 2018 at 8:49 am

#2013073
RE: Julian Date

irehman - Saturday, November 10, 2018 8:25 AM
I have a table called ORDER with columns OrderDate and OrderTime both are in Julian...
--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)

November 10, 2018 at 8:32 am

#2013071
RE: does use of large datatypes where much smaller ones will do, affect performance?

Eddie Wuerch - Friday, November 9, 2018 3:01 AM
polkadot - Wednesday, November 7, 2018 11:05 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)

November 10, 2018 at 8:15 am

#2013068
RE: Indexing Computed Columns

I believe you meant "not" rather than "now".
However, your first example is also non-deterministic. Here's the proof.
Create
--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)

November 10, 2018 at 8:00 am

#2013066

RE: How To Truncate Log with Transaction Replication

ken 16613 - Thursday, November 8, 2018 10:06 PM

Thanks @jeff. I didn't receive a notification from your reply for some reason.

For clarification,...

--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)

November 10, 2018 at 7:52 am

#2013065