Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,291 through 7,305 (of 59,091 total)

Reply To: String or Binary Truncation Error Strange Behavior

DB_Newbie2007 wrote:
Lordy. Thanks for the feedback on that. It's very timely as I was going to actually try column store on a table or two and then put them into...
--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)

April 16, 2020 at 1:49 pm

#3743415
Reply To: WITH (NOLOCK) vs READUNCOMMITED proper way / performance differences

rajthampi wrote:
Hello @jeff
I was referring Oracle in the context to explain how we "were" doing things until date & how the demand from new Solution provider to use WAIT(NOLOCK) with...
--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)

April 16, 2020 at 6:32 am

#3743317
Reply To: Do You Have a Mentor?

I think too many people think that a mentor should be a full time personal instructor. That's not how it is and that's why a lot of people don't want...
--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)

April 16, 2020 at 5:56 am

#3743315
Reply To: Teams That Ship

David.Poole wrote:
If you look at the agile manifesto it lists the principles in terms of x over y. For example people and processes over tools and technologies. It is explicit...
--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)

April 16, 2020 at 5:36 am

#3743312
Reply To: WITH (NOLOCK) vs READUNCOMMITED proper way / performance differences

rajthampi wrote:
Hello @Grant
Thank you very much. I've read about snapshots at StackOverFlow and few other places, however, my primary concern is not truly answered.
I would pry you to give me...
--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)

April 16, 2020 at 5:28 am

#3743310
Reply To: String or Binary Truncation Error Strange Behavior

DB_Newbie2007 wrote:
As a desperate try, we removed the index and suddenly the truncation error went away.
Lordy. Thanks for the feedback on that. It's very timely as I was going 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)

April 16, 2020 at 3:04 am

#3743299
Reply To: Teams That Ship

Steve Jones - SSC Editor wrote:
DevOps is a culture, but the culture isn't to write sloppy code faster. It's to release the changes, backwards compatible, quicker.
While I agree about the culture part of that,...
--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)

April 15, 2020 at 7:23 pm

#3743244
Reply To: String or Binary Truncation Error Strange Behavior

You say you tested and nothing exceeded 6 characters in the source table. If you use LEN() to do the test, you did it wrong. Use DATALENGTH() instead and see...
--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)

April 15, 2020 at 7:15 pm

#3743243
Reply To: Be Professional

Heh... this quote says it all about many situations...
"Lord give me patience because... If you give me strength, I'm gonna need bail money to go with 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)

April 15, 2020 at 7:04 pm

#3743241
Reply To: Teams That Ship

That's kind of what I'm talking about. It's difficult for many people (especially managers) to understand that, many times, the key to increasing velocity and efficiency is to slow down...
--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)

April 15, 2020 at 12:40 pm

#3743102
Reply To: Latest inserted records in tbl

You should read and understand the documentation on any functionality before you try to use it.
https://docs.microsoft.com/en-us/sql/t-sql/queries/top-transact-sql?view=sql-server-ver15
--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)

April 15, 2020 at 2:51 am

#3742986
Reply To: Teams That Ship

Heh... so many companies seem to have adopted the attitude of "We have to so something... even if it's wrong" and then they bitch about a slow release cadence with...
--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)

April 15, 2020 at 2:40 am

#3742984
Reply To: bcp format file and import fixed width text file

If you're going to split the data on the way in, even if it's just two columns, you're going to need a "Format File" to do it. If no one...
--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)

April 13, 2020 at 4:13 pm

#3742456
Reply To: Saving integers as varchar so that I can choose '' (empty) as content

Actually, Joe, I care very much about having a "corrected [sic] data model" and that's why I'm suggesting that having a NULL EndDate is the wrong way to do things. ...
--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)

April 13, 2020 at 3:55 pm

#3742446
Reply To: Stored Procedure

Understood but many such "in-house-only" application and other data has been compromised both when someone gets into the nickers of your "in-house" domain and from "inside-jobs" done by less than...
--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)

April 13, 2020 at 1:57 pm

#3742403

Viewing 15 posts - 7,291 through 7,305 (of 59,091 total)