Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,821 through 2,835 (of 59,086 total)

Reply To: Performance degradation - Help troubleshooting

Ok, so now find the code that's doing the blocking. One way to do that is to look sp_WhoIsActive by Adam Machanic or Brent Ozar's sp_BlitzCache, read the instructions, download...
--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)

September 6, 2022 at 3:04 pm

#4084505
Reply To: ACCELERATED_DATABASE_RECOVERY and increase in database size

Johan Bijnens wrote:
Make sure you're keeping up with these cumulative updates ! They fix a lot, but you'll have to test !
It's almost humorous as to the amount of irony 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)

September 6, 2022 at 2:57 pm

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

@Eirikur...
I guess that I'd hunt down the people that designed that "edge case" and introduce them to pork chop dinners in a major way.
Heh... reminds me of the battles 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)

September 6, 2022 at 2:52 pm

#4084499
Reply To: how to remove schemabinding from all functions and view in one go.
rajemessage 14195 wrote:
1. I want to remove the schema binding from all my functions, then want to apply but in one go, how can it be done?
2) I have few cols...
--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)
September 6, 2022 at 2:47 pm

#4084496
Reply To: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Henry B. Stinson wrote:
I wonder if instead of using literal number 8000, you could limit the number of rows in the first CTE
to count the number of delimiters in the string, 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)

September 6, 2022 at 4:41 am

#4084194
Reply To: world map and errors loading map for VS 2022

Why not reach out to the author of that article?
--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)

September 6, 2022 at 12:35 am

#4084171
Reply To: SSRS Rendering format Excel Change ?

feniss wrote:
I was wondering if anyone knew how I can change the Excel rendering format in the reportserverconfig file
so the default cell format is text and not General. If not,...
--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)

September 6, 2022 at 12:31 am

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

Ed Wagner wrote:
Grant Fritchey wrote:
Question for the smart people, and the rest of you.
Would you endorse or get behind the statement: Some deadlocks are healthy. or Some level of deadlocks is healthy.
Or...
--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)

September 6, 2022 at 12:08 am

#4084165
Reply To: last time index was re-org or rebuilt?

Knowing when the last index maintenance is nice to know... In conjunction with the two types of fragmentation, it helps alert you to which indexes might need some help 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)

September 5, 2022 at 9:24 pm

#4084151
Reply To: Labor Day 2022

BTW, Steve... Congratulations on MVP #15! WHOO_HOOO!
--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)

September 5, 2022 at 8:28 pm

#4084142
Reply To: Performance degradation - Help troubleshooting

So dig into that one query and find out what's going on with it and what's causing it to wait.
--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)

September 5, 2022 at 8:26 pm

#4084141
Reply To: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Henry B. Stinson wrote:
I wonder if instead of using literal number 8000, you could limit the number of rows in the first CTE
to count the number of delimiters in the string, 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)

September 5, 2022 at 8:21 pm

#4084140
Reply To: How do I query to exclude the "first position of a 3 digit number"

Heh... checking out the following link...
https://financesonline.com/10-biggest-hotelst-in-the-world-the-highest-number-of-rooms-to-stay-in/
... The entries that list the number of rooms, floors, and buildings seem to indicate that TinyInt will probably work just fine. You would need...
--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)

September 5, 2022 at 8:14 pm

#4084139
Reply To: How do I query to exclude the "first position of a 3 digit number"

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
I'd likely do similar but with TinyInt for each. There'd also be a usage category column.
Having been to Las Vegas in the last few years, not sure 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)

September 5, 2022 at 7:59 pm

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

Hugo Kornelis wrote:
Jeff Moden wrote:
It's just my opinion but that violates the rules of integer division
Why would you expect the rules of integer division to apply when the input data are not...
--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)

September 5, 2022 at 7:57 pm

#4084128

Viewing 15 posts - 2,821 through 2,835 (of 59,086 total)