Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,076 through 3,090 (of 59,098 total)

Reply To: Script entire db to find relevant Stored procedures

Please see my reply on the thread that spawned this need at
https://www.sqlservercentral.com/forums/topic/missing-datafinding-the-root-problem/page/2#post-4072000

--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 3, 2022 at 4:21 pm

#4072045
Reply To: How to Get Data Using Python in Power BI

Thank you for the feedback, Daniel. I appreciate it.
--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 3, 2022 at 4:13 pm

#4072043
Reply To: Script entire db to find relevant Stored procedures

yrstruly wrote:
Yes, i am trying to find out which stored procedure or table. I was just given this task and thrown in the deep end. I am still learning 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 3, 2022 at 4:06 pm

#4072039
Reply To: Missing Data(finding the root problem)

yrstruly wrote:
Yes, that can be the issue. Do you think it will work when there is data in that table?
You should try it and see. "One good test is worth...
--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 3, 2022 at 3:31 pm

#4072000
Reply To: How to Get Data Using Python in Power BI

Jeff Moden wrote:
With the understanding that I've never used Power BI, are you suggesting that Power BI cannot get data directly from SQL Server without having to use a language like...
--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 3, 2022 at 3:02 pm

#4071992
Reply To: Missing Data(finding the root problem)

yrstruly wrote:
Currently my "auditLevyBreakdown" table contains no data, it is suppose to have data in it.
Your function is grouping by columns from that table and it's empty??? Do you suppose...
--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 3, 2022 at 2:49 pm

#4071983
Reply To: Performance problem

wrote:
sometime i got same issue, how can i solve this
To be honest, this sounds like a setup for a SPAM update. If you're not a spammer, go back 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)

August 3, 2022 at 2:44 pm

#4071982
Reply To: search index

ScottPletcher wrote:
Jeff Moden wrote:
Who says? It didn't specify anything about the table. Consider it to be "most convenient". 😀
The OP said:
you want to search for all users who have an email...
--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 3, 2022 at 2:38 pm

#4071981
Reply To: Missing Data(finding the root problem)

Also, consider the fact that you're grouping by a table that is the "Right" table of a Left Join. Perhaps it would be better to get the data for 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 2, 2022 at 11:19 pm

#4071649
Reply To: Missing Data(finding the root problem)

For example... all the other tables are left joined vw_UsageReportCached view. So, remove everything else form the code not having to do with that view and see what you come...
--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 2, 2022 at 10:52 pm

#4071638
Reply To: Missing Data(finding the root problem)

Start tearing apart the query(ies) in the function. You know the data is available. Find out which part of the code in the function is preventing it.

--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 2, 2022 at 10:19 pm

#4071634
Reply To: Missing Data(finding the root problem)

That's reading from a function, not the view. You don't know if the function is the issue or the view.
--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 2, 2022 at 9:58 pm

#4071627
Reply To: Informatica data ingestion

It clearly states that you do NOT need to grant sys_admin privs...
source connection must have the sysadmin role, OR have the db_owner role and the SELECT permission 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)

August 2, 2022 at 9:38 pm

#4071622
Reply To: Extracting first three words from Address field

Kin16 wrote:
I am trying to standardize an address field. I want to extract the first three words of the full address (ex: 123 Main Street) into a new column. 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)

August 2, 2022 at 9:26 pm

#4071607
Reply To: search index

Who says? It didn't specify anything about the table. Consider it to be "most convenient". 😀
--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 2, 2022 at 8:51 pm

#4071599

Viewing 15 posts - 3,076 through 3,090 (of 59,098 total)