Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,261 through 7,275 (of 59,072 total)

Reply To: Real columns are comma separated instead of dot separated ?

Not sure but you may also have to for the language to "English", as well.
--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 19, 2020 at 11:21 pm

#3744031
Reply To: Entity Relationship diagram - Path and Node entities

Heh... Ok... I'll bite. Is it? 😉
I also wonder why people do this type of thing to perfectly good relational data.
--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 19, 2020 at 11:16 pm

#3744030
Reply To: Create Stored Procedure to create Indexes?

jbalbo wrote:
To be honest the vendor won't tell use. It is transaction replication for reporting
All I know is they won't turn on nonclustered inxedes in replication
thus the recreation each night
I'd...
--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 18, 2020 at 2:07 am

#3743913
Reply To: The Conferences of the Future

Nah... I gotta agree... face time is better than any 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 18, 2020 at 1:58 am

#3743912
Reply To: The Conferences of the Future

I don't mind giving online presentations at all because I don't do much differently. During in person presentations, I actually tell people not to look at me but, rather, 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 17, 2020 at 4:50 pm

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

Steve Jones - SSC Editor wrote:
I've unspammed it. While it did look funny, I didn't take it that way. Mainly because I've seen quite a few posts from SCDecade.

BWAAA-HAAAA!!! So you've been watching him...
--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 8:54 pm

#3743583
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

Viewing 15 posts - 7,261 through 7,275 (of 59,072 total)