Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,041 through 5,055 (of 59,089 total)

Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Ads always ask for more than the job. I don't know that I've seen one that was accurate since I stopped tending bar.
If you think you have to meet...
--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 30, 2021 at 5:23 pm

#3902143
Reply To: Top SQL Queries to Safeguard JIRA

My opinion is that if a product has so many performance issues, perhaps it's better to find a different product. Atlassian is obviously aware of the performance problems, especially because...
--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 30, 2021 at 3:50 pm

#3902108
Reply To: column count per table best practice

Jeffrey Williams wrote:
Jeff Moden wrote:
That's where you and I would differ... to me, the "customer number" would be the IDENTITY column. Or, perhaps, a Random GUID. 😀 Why would your "customer number"...
--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 8:29 pm

#3901790
Reply To: column count per table best practice

That's where you and I would differ... to me, the "customer number" would be the IDENTITY column. Or, perhaps, a Random GUID. 😀 Why would your "customer number" not 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 29, 2021 at 7:19 pm

#3901782
Reply To: when the data of sys.dm_exec_query_stats will be reset/removed

892717952 wrote:
I notice that even if we don't restart SQL Service, the data of sys.dm_exec_query_stats( sys.dm_exec_sql_text() and sys.dm_exec_query_plan() ) will be reset or removed/refreshed. when the data of sys.dm_exec_query_stats will...
--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 5:36 pm

#3901759
Reply To: column count per table best practice

It would be really interesting to see you design a Customer or Employee table without one. I'd also be interested in your claim of "it's literally impossible to normalize based...
--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 5:07 pm

#3901736
Reply To: column count per table best practice

Heh... so THAT's the reason why so many people end up with "slow databases" and IDENTITY columns everywhere. 😉 A lot of the important stuff isn't even considered up front.
--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:56 pm

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

Viewing 15 posts - 5,041 through 5,055 (of 59,089 total)