Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,961 through 3,975 (of 59,087 total)

Reply To: Speedy Break Fix

Steve Jones - SSC Editor wrote:
David.Poole wrote:
I think the important thing is to reflect on the lessons learned and ask what we would do better with the benefit of hindsight.
... The point is these...
--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)

February 7, 2022 at 8:20 pm

#3981190
Reply To: group records by week

Heh... wow... this post sure has taken a turn. What ever happened to "Get records by week"?
--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)

February 7, 2022 at 7:44 pm

#3981186
Reply To: Store invoke-sqlcmd result in PowerShell variable and use it for comparison

I'll add to that... look at what you're doing... You're writing T-SQL in PowerShell to do backups? Just write a stored procedure and then you don't have to worry about...
--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)

February 7, 2022 at 7:39 pm

#3981185
Reply To: Comparing nvarchar with string has started generating weird conversion error

shaunos wrote:
In fairness, as I mentioned before, these files have been fine for years except for this month but yes we will have to add some more defensive checks 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)

February 7, 2022 at 7:34 pm

#3981184
Reply To: Accessing variables dynamically

Pete Bishop wrote:
Any ideas?
Yep, but no one using SSIS seems to like it. Why not just use stored procedures without SSIS?
--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)

February 7, 2022 at 7:29 pm

#3981183
Reply To: Store invoke-sqlcmd result in PowerShell variable and use it for comparison

I can't help here but I have to tell you that putting passwords into clear text is a really bad idea. They really need to be "trusted" connections based 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)

February 6, 2022 at 9:01 pm

#3980987
Reply To: SSIS SFTP using WinSCP

Ah, got it. Thank you. Heh.... yep. Been there and done that myself.
--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)

February 6, 2022 at 8:57 pm

#3980986
Reply To: Comparing nvarchar with string has started generating weird conversion error

It always happens that way with such "no one made any changes" such things. 😀
It would be nice if you could post the actual code you're talking about so we...
--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)

February 6, 2022 at 5:18 pm

#3980977
Reply To: SSIS SFTP using WinSCP

water490 wrote:
i figured out the issue. ignore post.
Two way street here... Can you tell us, please?
--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)

February 6, 2022 at 3:54 pm

#3980966
Reply To: Comparing nvarchar with string has started generating weird conversion error

shaunos wrote:
Has anyone seen anything behaviour like this before?
Yes... and every time someone claims that something has been running for years and no one has made a change, someone has...
--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)

February 6, 2022 at 2:52 pm

#3980963
Reply To: CPU

I'd help on the hardware side of things but I'm not a hardware kind of guy anymore. I did see that your choices may be even more complex because there's...
--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)

February 6, 2022 at 2:38 pm

#3980961
Reply To: CPU

water490 wrote:
Hi everyone
I am in the market for a new computer. I have been comparing various Xeon processors and I am a bit confused by a few things. Intel lists...
--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)

February 5, 2022 at 7:55 pm

#3980906
Reply To: Saving changes is not permitted

Also, you should save yourself some time. USE the search engines for nearly instant answers especially when it comes to such error messages. This one only required the few words...
--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)

February 5, 2022 at 7:53 pm

#3980905
Reply To: What am I doing to get this message?

skeleton567 wrote:
Jeff Moden wrote:
I only get that error occasionally. It may have to do with whether or not someone posted while you were typing or waiting. Ok... just remembered who I'm...
--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)

February 5, 2022 at 7:50 pm

#3980904
Reply To: Saving changes is not permitted

To add to what Frederico posted, here's how you change the setting...
In SSMS, click on {Tools}{Oprionts} in the menu. Scroll down to {Designers} and expand it. Then click on {Table...
--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)

February 5, 2022 at 7:40 pm

#3980902

Viewing 15 posts - 3,961 through 3,975 (of 59,087 total)