Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,091 through 3,105 (of 59,098 total)

Reply To: Missing Data(finding the root problem)

yrstruly wrote:
@JeffModenI What is the correct way in testing a view? did post the view's code
I wasn't talking about the code for the view. I was talking about the simple...
--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:46 pm

#4071598
Reply To: search index

ScottPletcher wrote:
That is a simple q, I say give it a simple answer. There's no need to over-analyze every q or nit pick its wording.
You're missing the point, Scott. 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 8:27 pm

#4071590
Reply To: search index

marcelo salgado wrote:
Jeff: you text data was amazing!!! becouse that I undertood your point about the issue....and thanks to ScottPletcher for your explanation. My doubt was cleared.!
Thank you for the kind...
--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:16 pm

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

yrstruly wrote:
I tested the view and found that the columns in question does not contain any data, no matter what date range i choose. I also found that table 'auditLevyBreakdown'...
--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 3:20 pm

#4071433
Reply To: search index

"It Depends"on what "most convenient" means. You've just added an index that's going to do page splits all over the place unless you use a Fill Factor, which most will...
--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 3:14 pm

#4071431
Reply To: Issue "Error converting data type varchar to numeric."

The problem does NOT appear to have anything to do with the creation of the SMP_FLAG or the assignment of the letter 'X' to it or the use of 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 2:54 pm

#4071426
Reply To: Issue "Error converting data type varchar to numeric."

JeremyU wrote:
@jeff how can I then correct it?
I need to filter WHERE SMP_FLAG ='x'.
Then use THAT instead of what you have in the code you posted!!! 😉 Here's what 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)

August 2, 2022 at 2:38 pm

#4071419
Reply To: Send Mail Task Failed Using SSIS Package

kaj wrote:
Jeff Moden wrote:
I'm pretty sure that I'd remove the IP address and port from the original post. Just sayin'... you know... Security??? 😉
Hmmm... I'm pretty sure that IP address is...
--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 2:16 pm

#4071409
Reply To: Very slow db detach

Manisha93 wrote:
Show mercy on newbie 🙂
Heh... I did!
While it may come to having to do a reboot, recommending a reboot without qualification is a bad idea.
--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 2:08 pm

#4071408
Reply To: Issue "Error converting data type varchar to numeric."

That's some really bad code to troubleshoot, Jeremy. Someone not familiar with the tables would have a heluva time trying to figure what which columns come from which tables 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)

August 2, 2022 at 6:34 am

#4071220
Reply To: search index
I'm not going to answer your question. YOU are. Here's a test table that you can try all 3 answers on. Don't let the "million" row thing scare you... this...
- This reply was modified 4 years, 1 months ago by Jeff Moden. Reason: Added more suggestions/info
--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 3:48 am

#4071183
Reply To: how to Make a copy of Full Recovery DB and Restore it to a Simple Recovery Db

If your ldf is actually larger than your mdf, like you say it is, then you have a much worse problem on your hands. You need to find and fix...
--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, 2022 at 7:18 pm

#4071078
Reply To: Very slow db detach

Manisha93 wrote:
@chris4600
I had same issues , the detach query executed for 4 hours but didn't completed.
The solution worked for me is very simple. I dont know the reason behind 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 1, 2022 at 7:11 pm

#4071077
Reply To: Cloud path for beginners

ratbak wrote:
I suspect you meant "...relational databases are not going away."?
Absolutely correct. Can't believe I phat phingered that. Thank you for the catch.
--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, 2022 at 6:55 pm

#4071069
Reply To: SQL Using a PIVOT to Convert row data to column

Ok... so tell us how you got the numbers is the "after" graphic from the numbers in the "currently have" graphic. The don't add up.
--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, 2022 at 6:52 pm

#4071066

Viewing 15 posts - 3,091 through 3,105 (of 59,098 total)