Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,741 through 4,755 (of 59,069 total)

Reply To: Not getting expected index seek.

Looking at the Clustered Index for the oeordlin_sql table, I'm a wee bit concerned (especially for insert and update performance) over having the leading column be in the "ultra low...
--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)

August 24, 2021 at 6:34 pm

#3923608
Reply To: Detach - reattach database on a new drive on same server

I do the same as what Anthony posted.
There might be at least one caveat to be aware of. My disclaimer is that I've not had to try it and I'm...
--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)

August 24, 2021 at 5:59 pm

#3923598
Reply To: Is that a reason DBA should Install SQL Server

Our situation appears to be quite a bit different than yours (and no... neither is wrong, IMHO... they're just different because of different business requirements). My best friend, who 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)

August 24, 2021 at 5:47 pm

#3923593
Reply To: Advantage of having multiple files is a filegroup designated for LOBs ?

I've probably just not had enough coffee yet, Johan, but the data you posted doesn't look like a performance comparison to me. It looks like measurements from a single run.
I...
--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)

August 24, 2021 at 4:00 pm

#3923551
Reply To: A Lack of Error Handling

Kazoo1989 wrote:
Our company uses EF and stored procedures with error handling. Our standard is to require Try/Catch blocks in all stored procedures. While I agree with Jeff Moden's point in...
--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)

August 24, 2021 at 7:20 am

#3923387
Reply To: Is that a reason DBA should Install SQL Server

Correct. We never do multiple named instances on a server. Heh... they still haven't found the body of the last person that tried to do that on our servers. 😀
Instead...
--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)

August 24, 2021 at 7:12 am

#3923385
Reply To: Update stats

If you are using REORGANIZE on any rowstore index that is fragmenting, STOP IT! PERIOD!. REORGANIZE does not work like you probably think it works. It can and...
--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)

August 23, 2021 at 10:42 pm

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

Luis Cazares wrote:
Count me as one of the people that left because of the changes in the site. I keep coming to read the thread, but with the decline of questions...
--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)

August 23, 2021 at 9:32 pm

#3923301
Reply To: SSIS Package started failing for no obvious reason

I wonder if it was because of the flow change you made in the package or it's because you "re-saved" the package (and I might be using the wrong term...
--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)

August 23, 2021 at 2:52 pm

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

Sean Lange wrote:
Jeff Moden wrote:
J Livingston SQL wrote:
Thanks for the "Welcome back" Jeff....appreciated. I doubt that many potential new users of the site would stay around for very long...cos to be honest the site...
--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)

August 23, 2021 at 1:51 pm

#3922847
Reply To: A Lack of Error Handling

olliesignup wrote:
I'd love to know how many users in this forum are exclusively Entity Framework developers and believe that stored procedure are "a memory of a bygone era."?? hahah

That's one...
--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)

August 23, 2021 at 1:27 pm

#3922841
Reply To: A Lack of Error Handling

For us, stored procedures aren't a by-gone era. Instead, we embrace them. We tried letting the ORM (whatever flavor it was over time) do some of the complicated things and...
--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)

August 23, 2021 at 1:24 pm

#3922838
Reply To: What Counts for a DBA: Skill

will 58232 wrote:
There is a great deal of misunderstanding about relational DBMSs and you will find a lot of this misunderstanding out there on the internet.
For example, people talk about a ...
--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)

August 23, 2021 at 1:03 pm

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

J Livingston SQL wrote:
Thanks for the "Welcome back" Jeff....appreciated. I doubt that many potential new users of the site would stay around for very long...cos to be honest the site is beyond...
--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)

August 23, 2021 at 12:26 pm

#3922811
Reply To: Trying to understand parentheses placements

J Livingston SQL wrote:
Never knew about that Jeff......thanks muchly
Heh... Welcome back my ol' friend.
--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)

August 23, 2021 at 12:19 pm

#3922810

Viewing 15 posts - 4,741 through 4,755 (of 59,069 total)