Jeff Moden

Forum Replies Created

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

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

RE: [N]Varchar(4000) and Performance

p.s. You should write an article on it.

--Jeff Moden

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:48 am

#2013064

RE: [N]Varchar(4000) and Performance

Very cool stuff, Eddie. Added that to my briefcase. Thanks for taking the time to do the experiment and post the results and the explanation!

--Jeff Moden

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:48 am

#2013063

RE: The Cost of Switching

Steve Jones - SSC Editor - Monday, February 2, 2015 8:27 AM

David.Poole (1/31/2015)

Real DBAs script things because their tasks have to be...

--Jeff Moden

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:26 am

#2013062

RE: Error while restoring a database from a backup

1. If you're trying to do a restore over an existing database, you need to use the REPLACE option. Remember that this will overwrite the existing database and, if...

--Jeff Moden

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:10 am

#2013061