Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,951 through 10,965 (of 59,102 total)

RE: Are the posted questions getting worse?

DesNorton - Monday, October 15, 2018 12:13 PM
Brandie Tarvin - Monday, October 15, 2018 12:12 PM
--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)

October 15, 2018 at 5:10 pm

#2009775
RE: SQL Query Questions Answers

A lot of people as for questions to help them prep for interviews for jobs that they're not actually qualified to do. It's given me a bit of a jaundice...
--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)

October 15, 2018 at 5:08 pm

#2009774
RE: Anyone see a problem with this?

SQLStud 74876 - Monday, October 15, 2018 3:45 PM
I'm actually restructuring all of the tables that this guy (the OP) created.
Flat...
--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)

October 15, 2018 at 4:58 pm

#2009772
RE: Table growing excessively when updating column

gerben.scherpenzeel - Monday, October 15, 2018 8:25 AM
I have got an issue that is driving me nuts.
There is table in an Azure...
--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)

October 15, 2018 at 2:50 pm

#2009750
RE: Table growing excessively when updating column

And stop adding and deleting columns. Populate the table with the "new" column in place and, if it's variable width, make sure that you default it with SPACE(X) where "X" 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)

October 15, 2018 at 2:48 pm

#2009748
RE: SQL Query Questions Answers

It's not possible for us to tell if you'll be the interviewer or the interviewee. 😉
--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)

October 15, 2018 at 2:45 pm

#2009747
RE: Table growing excessively when updating column

Grant Fritchey - Monday, October 15, 2018 12:27 PM
That's.... a lot.
From an update I can imagine a scenario where you get quite...
--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)

October 15, 2018 at 2:41 pm

#2009745
RE: Query slow. Help improve?

SQLStud 74876 - Monday, October 15, 2018 12:04 PM
Jeff Moden - Saturday, October 13, 2018 10:25 AM
--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)

October 15, 2018 at 12:43 pm

#2009706
RE: Is this query correct ?

ChrisM@Work - Monday, October 15, 2018 7:58 AM
Jonathan AC Roberts - Monday, October 15, 2018 7:51 AM
--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)

October 15, 2018 at 12:20 pm

#2009693
RE: What's wrong with my table?

It's official, folks. The man is NOT an idiot. Rather, he's quite clever, as I suspected. Please see the following post.
https://www.sqlservercentral.com/Forums/FindPost2003341.aspx
--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)

October 15, 2018 at 12:19 pm

#2009690
RE: Compare of variables and handling nulls

Phil Parkin - Monday, October 15, 2018 5:20 AM
allan.ford17 - Sunday, October 14, 2018 9:18 PM
--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)

October 15, 2018 at 7:59 am

#2009616
RE: Text Delimiter in BCP

SATYA R - Monday, October 15, 2018 4:34 AM
-T is trusted mode but our case it is not applicable because file was...
--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)

October 15, 2018 at 7:58 am

#2009612
RE: Sorting by a column when the name is derived via a CASE statement

j.clay 47557 - Monday, October 15, 2018 7:40 AM
Thanks Jonathan 🙂
Here is my SQL:
select distinct cast(c.serialnumber AS INT), c.firstname, c.keyname, c.addressline1, c.addressline3,...
--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)

October 15, 2018 at 7:45 am

#2009606
RE: Modeling and Design Are More Important in DevOps

Gotta disagree here based on the title. Modeling and Design have ALWAYS been and CONTINUE to be important. DevOps doesn't make it more important.
--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)

October 15, 2018 at 7:38 am

#2009601
RE: Are the posted questions getting worse?

Thom A - Monday, October 15, 2018 7:26 AM
Pretty sure this is a prime reason why people are still using the ANSI-89...
--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)

October 15, 2018 at 7:35 am

#2009600

Viewing 15 posts - 10,951 through 10,965 (of 59,102 total)