Jeff Moden

Forum Replies Created

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

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
RE: Is this query correct ?

Thom A - Monday, October 15, 2018 6:47 AM
When was that book written, the early 90's? JOIN syntax is almost 30...
--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:34 am

#2009599
RE: Init-cap the characters in SQL server

jonas.gunnarsson 52434 - Monday, October 15, 2018 7:07 AM
Jeff Moden - Friday, October 5, 2018 6:57 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:24 am

#2009592
RE: sp_rename and stored procedures

Man... what a way to obfuscate code if you're building some sort of data dictionary from sys.sql_modules. Although the rename fails to change the stored procedure there, it does change...
--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 14, 2018 at 11:10 pm

#2009535

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