Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,061 through 3,075 (of 59,067 total)

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 3 years, 10 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
Reply To: Missing Data(finding the root problem)

Step 1 would be to query just the view to see if the date range returns anything. Then add a piece of your query for one of the joins 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 1, 2022 at 6:46 pm

#4071065
Reply To: Index created in the last few days

If your system is like mine, the data in the default trace lasts about 6 seconds. 😉
--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:33 pm

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

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 Python?
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)

August 1, 2022 at 4:55 am

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

I'm pretty sure that I'd remove the IP address and port from the original post. Just sayin'... you know... Security??? 😉
--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, 2022 at 7:24 pm

#4070655
Reply To: Intermittent "nesting level exceeded" error

I just checked the MS documentation... Here's the link of the document section I'm looking at.
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql#recursive-triggers
It's amazing to me that this is still only a server level option but...
--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, 2022 at 7:10 pm

#4070654
Reply To: Intermittent "nesting level exceeded" error

michio42 wrote:
That other table has a trigger, but no write operations, other than to itself.
Just at a quick glance, I'm thinking the above from your original post is the source...
--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, 2022 at 6:54 pm

#4070652

Viewing 15 posts - 3,061 through 3,075 (of 59,067 total)