Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,301 through 9,315 (of 59,091 total)

Reply To: Total Field On Monthly Grouped Matrix

I can't speak to using a matrix because I don't use SSRS. I do write stored procedures to provide info to SSRS and Excel, etc. If it were me, I'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 13, 2019 at 4:30 pm

#3641594
Reply To: Preventing a SELECT

Stewart "Arturius" Campbell wrote:
Nice, easy one to start the week on, thanks Steve
At the time of this post, I see that 18% (a whopping 42 out of 230) of the folks 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 13, 2019 at 4:22 pm

#3641591
Reply To: Preventing a SELECT

Bill wrote:
"other people will want access". Could you be a little more specific as to whether you intend to provide access to those people?
It doesn't actually matter. Whether that possibility...
--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 4:19 pm

#3641588
Reply To: Backup Job Performance

Let's stop an think about this... the backups didn't use to be a problem and moving to the new hardware is now causing a problem. It could be anything from...
--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 4:15 pm

#3641586
Reply To: Delete is very slow

Guras wrote:
Yes, the indexing on the FOREIGN KEY on the referencing tables did it. Thank you !
Awesome. Thanks for the feedback.
--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:44 pm

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

Michael L John wrote:
While we are on the subject of 4 part names and consistency across environments, it reminds me of a DBA who I had the pleasure(!) of following three separate...
--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:42 pm

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

Brandie Tarvin wrote:
That's why we don't use server names as linked server names. We use names (like Reports) that can remain consistent regardless of the environments. EDIT: The linked server...
--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:37 pm

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

Viewing 15 posts - 9,301 through 9,315 (of 59,091 total)