Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,161 through 17,175 (of 59,101 total)

RE: Shiny new server - split temp db files question

Eirikur Eiriksson (8/1/2016)
Quick question, have you set the TFs 1117 & 1118?
😎
Setting TF1118 is cool but setting TF1117 comes with some serious problems if you have partitioned tables that use...
--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 5:06 pm

#1893090
RE: How do you turn off an instance of Azure?

So... Like I said... "Nukes". 😀
--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:35 pm

#1893087
RE: massive i/o bottleneck

Unless you can guarantee that tables will be split across multiple separate physical spindles, splitting up an MDF file may actually slow things down even worse than they are now....
--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:34 pm

#1893086
RE: Suggestions to Track Data

mbrady5 (8/1/2016)
Thanks for the reply. I created what I was looking to do.
What method(s) did you use?
--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:18 pm

#1893085
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

Viewing 15 posts - 17,161 through 17,175 (of 59,101 total)