Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,316 through 9,330 (of 59,099 total)

Reply To: NOT IN with OpenRowSet

As some of the techs I work with would say, "Cool beans". Thanks for the feedback on this.
As a bit of a sidebar, this is yet another proof that correct...
--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, 2019 at 3:29 pm

#3641537
Reply To: Are the posted questions getting worse?

Sean Lange wrote:
Brandie Tarvin wrote:
I don't think he was talking about using linked servers to update the AG jobs, logins and whatnot. I think he was about to go off on a...
--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, 2019 at 3:12 pm

#3641519
Reply To: Performance tuning of hierarchy based query

Yes, I do understand how your hierarchy is setup and I understand that the ID column is just an integer. What I'm saying is that it has not been included...
--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, 2019 at 3:07 pm

#3641513
Reply To: The Basics - Level 1 of the Stairway to Query Store

Great intro, Carlos. Very much looking forward to the rest of this series especially since we've not used Query Store on our systems, yet.
Shifting gears a bit, a lot 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)

May 13, 2019 at 1:27 pm

#3641461
Reply To: Performance tuning of hierarchy based query

sqlenthu 89358 wrote:
#temp_Mainhier contains around 500000 and #temp_SecondaryHierLeaf contains around 200000 records.
I'm not groking what you need to do but it seems like you're going to have perpetual problems because you...
--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, 2019 at 11:41 am

#3641382
Reply To: General SQL Development Question.

Ok... I guess the last question is how you uniquely identify the rows. What are the columns and datatypes for what could be used as a PK?
--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 12, 2019 at 7:03 pm

#3641063
Reply To: NOT IN with OpenRowSet
Ok. I don't have your "v_Manufac" view to test against but give this a try.
```
--===== Note that the following characters are replaced with an empty string if...
```
--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 12, 2019 at 5:39 pm

#3641025
Reply To: NOT IN with OpenRowSet

TJ_T wrote:
The text file just contains a list of Models: GRX, TRX, VRX, WRX, NRX, PRX
So each entry is on a separate line in the file? And all lines...
--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 12, 2019 at 1:10 pm

#3640914
Reply To: NOT IN with OpenRowSet

TJ_T wrote:
I have no choice. I can't - not allowed to store in a table. I have to use a text file 🙁 I have been trying LTRIM and no...
--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 12, 2019 at 2:03 am

#3640738
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
Considering the recent events on this site and the huge losses in functionality, you're preaching to the choir there. 😉 The impetus seems to have been...
--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 12, 2019 at 1:11 am

#3640718
Reply To: NOT IN with OpenRowSet

TJ_T wrote:
Yes I thought of LTRIM - just wasn't sure how to do it with this query:
That was my main question and you've not answered it yet. Why on...
--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 12, 2019 at 12:51 am

#3640712
Reply To: backup failed

atulyan.aries wrote:
Hello Team, I'm getting the following error: BACKUP failed to complete the command BACKUP DATABASE db name. Check the backup application log for detailed messages. In our system...
--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, 2019 at 11:16 pm

#3640688
Reply To: SAN backups vs SQL Server native

To personify what Sergiy stated, I worked for a company that insisted that they didn't need native backups because they were doing "San Snapshots" every 20 minutes. I insisted that...
--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, 2019 at 9:44 pm

#3640659
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
The lessons of loss just don't rub off until someone experiences the issue themselves. No idea how to teach this, other than to provide some examples and try to...
--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, 2019 at 9:10 pm

#3640647
Reply To: Are the posted questions getting worse?

Grant Fritchey wrote:
I'm doing a precon at Columbus. SPEND YOUR MONEY!!!!!

Heh... Grant is fantastic at teaching but sucks when it comes to self promotion or promotion for a cause. 😀 :D...
--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, 2019 at 8:32 pm

#3640640

Viewing 15 posts - 9,316 through 9,330 (of 59,099 total)