Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,361 through 12,375 (of 59,099 total)

RE: Hierarchical query match with multiple tables

I grok your question.
First, you've been around long enough for you to start helping the people that you want help from. Please read and heed the article...
--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)

May 13, 2018 at 11:16 am

#1990291
RE: Recursive with multiple first lines

ross.hughes - Friday, May 11, 2018 8:26 AM
That looks like it is working, Jeff. There was only an extra parenthesis 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)

May 11, 2018 at 4:28 pm

#1990259
RE: Rebuilding Indexes very often is good?

WonderPra - Friday, May 11, 2018 12:44 PM
No rush but I am looking forward for you to release an article or post...
--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)

May 11, 2018 at 4:16 pm

#1990257
RE: Prepare a stored procedure work flow diagram

To me, regurgitating the actual code as a diagram is very nearly useless, especially in SQL Server. And, to me, creating any diagram without documenting in the code itself is...
--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)

May 11, 2018 at 11:49 am

#1990234
RE: Recursive with multiple first lines

I've not tested it because I'm on my way to work but I believe this will get you to where you want to be with the character based Supply Job...
--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)

May 11, 2018 at 7:41 am

#1990189
RE: Recursive with multiple first lines

Hmmm.... is there an integer column on the original supply job table that acts like a surrogate key for the Supply Job Number?
--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)

May 11, 2018 at 7:23 am

#1990186
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Friday, May 11, 2018 5:58 AM
Jeff Moden - Thursday, May 10, 2018 10:55 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)

May 11, 2018 at 7:20 am

#1990185
RE: Recursive with multiple first lines

ross.hughes - Friday, May 11, 2018 7:03 AM
Hi Jeff,
I ran in to a little wrinkle in this line:
hPath = CONVERT(VARBINARY(4000),CONVERT(BINARY(4),CONVERT(INT,ISNULL(SupplyJob,'9999999'))))
My Supply...
--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)

May 11, 2018 at 7:14 am

#1990183
RE: Rebuilding Indexes very often is good?

It was great meeting you tonight, Pra. Thank you for the great questions and thank you for introducing yourself. It was a pleasure.
--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)

May 10, 2018 at 10:57 pm

#1990142
RE: Are the posted questions getting worse?

Man, I'm in 7th heaven tonight. Chris Morris was taking a vacation in Florida with some friends that live there and he flew up here today to see myself and Ed...
--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)

May 10, 2018 at 10:55 pm

#1990141
RE: Performance Question

ah0996 - Thursday, May 10, 2018 10:53 AM
Hi there,
I have a performance question here:
how can I rewrite below highlighted area? I 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)

May 10, 2018 at 11:05 am

#1990084
RE: Automated Indexes

Stewart "Arturius" Campbell - Thursday, May 10, 2018 5:44 AM
Jeff Moden - Thursday, May 10, 2018 5:10...
--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)

May 10, 2018 at 9:30 am

#1990067
RE: Has anyone written a Faceted Search like the ElasticUI interface ... all in SQL?

bvaljalo-1000038 - Wednesday, May 9, 2018 4:30 PM
If you go to dubdubdub elasticui dotcom and look at the bottom-most screenshot, I need...
--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)

May 10, 2018 at 5:39 am

#1990010
RE: will this SQL trigger recursive

patrick-330430 - Wednesday, May 9, 2018 10:04 PM
I am new on writing and testing trigger. I am trying to write a trigger...
--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)

May 10, 2018 at 5:28 am

#1990005
RE: Corruption of the file format .mdf

The latest full, dif, and transaction log backups will probably be needed for a restore for this 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)

May 10, 2018 at 5:20 am

#1990004

Viewing 15 posts - 12,361 through 12,375 (of 59,099 total)