Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,771 through 4,785 (of 59,089 total)

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
Reply To: Are the posted questions getting worse?

What the heck just happened with our profiles? I just did windows updates, which actually logged me off of SQLServerCentral and when I logged back in and checked my profile,...
--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 22, 2021 at 10:54 pm

#3922646
Reply To: Cursor replacement suggestions

Bruin wrote:
ANy more suggestions for the re-write?
If you want any more advice on this one, send money. 😀
--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 22, 2021 at 10:15 pm

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

Agreed... That's why I have stated multiple times that this was for a single batch INSERT and that folks need to look at Paul Randal's article that I cited for...
--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 22, 2021 at 10:13 pm

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

Ok. I wasn't believing my eyes and ran some code a couple of times. Basically, the code build a decent size table with a Bigint column and a LOG column...
--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 22, 2021 at 7:47 pm

#3922625
Reply To: Restart SQL Server to create space on disk

Personally, I never install SQL Server on the C:Drive. I also never let the "Page File" live there and I also install all programs other than SQL Server on 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 22, 2021 at 4:21 pm

#3922602

Viewing 15 posts - 4,771 through 4,785 (of 59,089 total)