Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,026 through 5,040 (of 59,072 total)

Reply To: Are the posted questions getting worse?

Sergiy wrote:
Jeff Moden wrote:
Do you have an actual example of a 30 million row transaction where every row was actually required or you had to fail all 30 million rows? ...
--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)

June 29, 2021 at 4:53 pm

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

Steve Jones - SSC Editor wrote:
When I see that list, I'm not at all scared. I've seen many descriptions, not just in tech, but in medicine, legal, hospitality, etc. where a job ad 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)

June 28, 2021 at 5:33 pm

#3901320
Reply To: column count per table best practice

Bredon wrote:
Presumably you are defining the PRIMARY KEYs as such, rather than using UNIQUE constraints? PRIMARY KEYs 'default' to being clustered. Broadly speaking clustering improves performance. These days, for permanent...
--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)

June 28, 2021 at 3:43 pm

#3901264
Reply To: column count per table best practice

Ok... I'm pretty sure that I was correct so here it is again.
You can't actually define a "field" as being unique. Instead, an unique index must be created. That can...
--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)

June 28, 2021 at 3:12 pm

#3901248
Reply To: column count per table best practice

Post withdrawn... gotta check on something...
--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)

June 28, 2021 at 3:03 pm

#3901242
Reply To: column count per table best practice

Ben wrote:
Thank you all!
One more question though not fully related to this topic, for UNIQUE fields, is there a difference to define UNIQUE at column definition and/or while defining index?...
--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)

June 28, 2021 at 3:02 pm

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

Sergiy wrote:
Jeff Moden wrote:
Ed Wagner wrote:
Jeff Moden wrote:
That might also be the reason why they've done the RBAR thing in the trigger. They don't want to have everything during and Insert or Update...
--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)

June 28, 2021 at 2:53 pm

#3901231
Reply To: Reading and Writing your Database's Documentation using JSON
ZZartin wrote:
Jeff Moden wrote:
I guess I don't understand two things...
1. Why you would ever want the documentation to be separate from the database.
2. Why on Earth you would want the result...
--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)
June 28, 2021 at 2:26 pm

#3901215
Reply To: column count per table best practice

Ben wrote:
I want to design a database for an OLTP app where it mainly involves customer and transaction. I know we have up to 1024 columns in a table, but...
--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)

June 28, 2021 at 12:39 pm

#3901164
Reply To: Reading and Writing your Database's Documentation using JSON
I guess I don't understand two things...
1. Why you would ever want the documentation to be separate from the database.
2. Why on Earth you would want the result to be...
--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)
June 28, 2021 at 12:29 pm

#3901157
Reply To: Seeking input on Best Method to Join on First or Last Row in a 1:M Join

None of that actually has anything to do with the OP's table except that you've done the same unnecessary expansion of a column like you claim he did with 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)

June 25, 2021 at 8:12 pm

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

Some good but with little to no experience??? Dude, suck them up and train them before someone corrupts them. 😀
--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)

June 25, 2021 at 7:53 pm

#3900627
Reply To: create total record in html email

Bruin wrote:
Totally Awesome!!!!
Many Thanks!!!!
Ok... so let's see your final output as an attached file, please.
--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)

June 25, 2021 at 4:38 pm

#3900502
Reply To: When to use calculated columns in SQL Server

Brent Ozar wrote an article about how they can force you query to go single threaded even if you're query is absolutely perfect in every other way and even when...
--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)

June 25, 2021 at 3:57 am

#3900286
Reply To: Seeking input on Best Method to Join on First or Last Row in a 1:M Join

jcelko212 32090 wrote:
(inmate_nbr CHAR(18) NOT NULL PRIMARY KEY, -- required, not optional.
Man... talk about a worse practice ever. If you're going to do something this silly, use a GUID... at least...
--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)

June 25, 2021 at 2:58 am

#3900276

Viewing 15 posts - 5,026 through 5,040 (of 59,072 total)