Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,176 through 2,190 (of 59,082 total)

Reply To: bcp out from sql table rows are breaking divided into rows two or three rows

Does any of the data itself contain a control code for a carriage return or line feed?
It's also a really bad thing to include logins and passwords in clear text. ...
--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)

January 4, 2023 at 5:22 pm

#4133620
Reply To: Create a Job Schedule that runs on the 1st of month only if it falls on a Sunday

Eirikur Eiriksson wrote:
Jeff Moden wrote:
I don't believe you need a date table for this. It would just be another thing to worry about. I'd use a method similar to what Ant-Green used.
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)

January 4, 2023 at 5:18 pm

#4133618
Reply To: The Tech That is Gone

Heh... Rick and I are "old tech" and we still work just fine. 😀

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

January 4, 2023 at 5:13 pm

#4133617
Reply To: record loading
You're still using this junk...
```
convert(date,DATEADD(s,t_stamp/1000,''1969-12-31 20:00:00'')
```
There's no need to convert the time stamps on the remote server to date time. You also already know how to convert...
--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)
January 4, 2023 at 2:56 pm

#4133548
Reply To: Where clause filter view before dense rank

Steve Collins wrote:
Jeff Moden wrote:
Except for the occasional Indexed View, this is one of the many reasons why I hate views.
Ha my exception is for VIEWS with INSTEAD OF triggers
Cool and timely...
--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)

January 4, 2023 at 12:37 am

#4133289
Reply To: Where clause filter view before dense rank

Except for the occasional Indexed View, this is one of the many reasons why I hate views.
Instead, try a "parameterized inline view" better known as an "Inline Table Valued Function"...
--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)

January 4, 2023 at 12:13 am

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

Steve Jones - SSC Editor wrote:
Happy New Year, everyone, and welcome to 2023!
Thanks, Steve, and thanks for taking care of this Website and all that you do for the community!
--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)

January 3, 2023 at 11:50 pm

#4133268
Reply To: Create a Job Schedule that runs on the 1st of month only if it falls on a Sunday

I don't believe you need a date table for this. It would just be another thing to worry about. I'd use a method similar to what Ant-Green used.
--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)

January 3, 2023 at 6:10 pm

#4133153
Reply To: Looking for SQL Architect

It'll be interesting how this works out. I know people that claim to have been "working with" SQL Server and they still don't have a good clue, never mind "working...
--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)

January 3, 2023 at 5:24 pm

#4133123
Reply To: Indexes: When Column Selectivity Is Not Always A Requirement

@ Mike Byrd... thank you for the great article. I obviously missed it when it first came out and I'm glad they republish such things to give such articles 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)

January 3, 2023 at 3:09 pm

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

David Burrows wrote:
Jeff Moden wrote:
Eirikur Eiriksson wrote:
Happy new year everyone! 😎 May the source be with you 😉
Same to you, ol' friend. Glad I got to know you and others from this site. ...
--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)

January 3, 2023 at 2:18 pm

#4133047
Reply To: Step functions trigger rule

@panirwane ,
I'd provide an answer but I don't even know how to spell AWS. Hopefully, someone out the will be able to respond.
--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)

January 3, 2023 at 1:25 am

#4132832
Reply To: Step functions trigger rule

Duplicate posts from only 2 days ago are probably not spam. Lot's of people post to multiple sites. This also doesn't seem (yet) to have the usual qualities of 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)

January 3, 2023 at 1:22 am

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

Eirikur Eiriksson wrote:
Happy new year everyone! 😎 May the source be with you 😉
Same to you, ol' friend. Glad I got to know you and others from this site. Missed seeing...
--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)

January 2, 2023 at 5:22 am

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

Thanks for the links, Steve. I wouldn't even know where to begin any more.
--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)

January 2, 2023 at 1:41 am

#4132542

Viewing 15 posts - 2,176 through 2,190 (of 59,082 total)