Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,131 through 17,145 (of 59,067 total)

RE: A twist on recursive query

Jeff Moden (7/31/2016)
michael.lock@aer.ca (7/26/2016)
You've hit upon the "twist" part. I could be approaching this wrong. I'm assuming a recursion approach because to me this looks like a classic...
--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)

August 1, 2016 at 4:14 pm

#1893084
RE: A twist on recursive query

Nested Sets, themselves, probably won't help much with flattening this hierarchy as requested by the OP. Further, most conversion methods for Nested Sets are terribly slow because of 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)

August 1, 2016 at 4:13 pm

#1893083
RE: Add New Column with RowID

Nusc (7/31/2016)
IF you don't mind saving that xlsx as a csv file and importing as a flat file source so there are no differences would be great.
Year , name, latitude,...
--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)

August 1, 2016 at 3:53 pm

#1893082
RE: Add New Column with RowID

Nusc (7/31/2016)
Why? Just import the xlsx file. There's too many entries.
I also reuploaded the file to include headers.
I'm planning on importing your data. I'd like to know what 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)

July 31, 2016 at 7:07 pm

#1892849
RE: A twist on recursive query

michael.lock@aer.ca (7/26/2016)
You've hit upon the "twist" part. I could be approaching this wrong. I'm assuming a recursion approach because to me this looks like a classic instance 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)

July 31, 2016 at 7:00 pm

#1892847
RE: Very generic question

sqlenthu 89358 (7/26/2016)
Hi all, I have a very generic question which may sound stupid but very important to me. I'm going to join new team as a database developer 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)

July 31, 2016 at 6:23 pm

#1892845
RE: Add New Column with RowID

Nusc (7/31/2016)
I am open to that option but I need to do what's required in this link:
https://dba.stackexchange.com/questions/24954/convert-spatial-points-data-to-line-data-for-use-in-line-layer-in-sql-server-rep
THe issue with what Jeff wrote is that for my actual data,
In one 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)

July 31, 2016 at 5:57 pm

#1892842
RE: Add New Column with RowID

Nusc (7/31/2016)
Hi, in the following example in this link:
https://stackoverflow.com/questions/11116275/increment-row-number-on-group
Suppose I want do add a new column s_index and order by shade.
It would look like the following:
Update MY_TABLE
SET s_index = (Select...
--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)

July 31, 2016 at 4:27 pm

#1892838
RE: Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

Thanks, Joe. I'm right there with you on the use of stored procedures.
CELKO (7/31/2016)
I tend to go one step further, and try to make everything look like SQL/PSM. I...
--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)

July 31, 2016 at 3:00 pm

#1892829
RE: do not set any locking\blocking

Mad-Dog (7/31/2016)
they know about the problem and for now they can't fix the problem.
table scan is not good because some tables can have even millions rows for they...
--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)

July 31, 2016 at 2:55 pm

#1892828
RE: do not set any locking\blocking

Eddie Wuerch (5/27/2016)
If you have a support agreement, call them up and scream at them.
+1000 to this. Call the software provider up and show them what's going on with...
--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)

July 31, 2016 at 6:20 am

#1892811
RE: Performance tuning on Production systems ??

As with all else in the world of databases, "It Depends".
While I agree that production shouldn't be used as a testing system, it's rare that any other system will 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)

July 31, 2016 at 6:16 am

#1892810
RE: delete spamming Account please

Steve Jones - SSC Editor (7/30/2016)
A tiny fraction
A "tiny fraction". Did you actually look at the spam today?
--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)

July 30, 2016 at 7:10 pm

#1892790
RE: Join resultset from SP_WhoIsActive

Yes. Ask the author of sp_WhoIsActive. 😉 Or learn how to use OPENROWSET. :w00t:
--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)

July 30, 2016 at 12:57 pm

#1892767
RE: Partition Help

N.B. (7/30/2016)
Jeff Moden (7/30/2016)
Don't partition, then. It's doing nothing for you. It's not going to help performance and it's not going to help with your night maintenance. ...
--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)

July 30, 2016 at 12:31 pm

#1892765

Viewing 15 posts - 17,131 through 17,145 (of 59,067 total)