Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,791 through 2,805 (of 59,067 total)

Reply To: Unable to add NOT NULL constraint (Msg 102, Level 15, State 1)

Or, setup a Default and use the WITH VALUES option,
The end result is the same though. There cannot be any NULLs in a NOT NULL 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)

September 6, 2022 at 6:13 pm

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

ScottPletcher wrote:
I'd strongly urge you to avoid a tinyint. Mainly because the room number is "904", not just 4 (and not 94). If you think about it, "room 4" 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)

September 6, 2022 at 6:11 pm

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

Eirikur Eiriksson wrote:
Jeff Moden wrote:
@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...
--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:44 pm

#4084532
Reply To: MDF size increasing without table size increase

p,s, Also, are you using sp_SpaceUsed with the "updateusage" option enabled? If not, you need to start.
--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:33 pm

#4084528
Reply To: MDF size increasing without table size increase

ps. wrote:
MarkP wrote:
That's strange, it should run in less than a second.
Do you have a DBA to refer this to or are you the DBA for this?
I'm the DBA. We...
--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:30 pm

#4084515
Reply To: SQL Server Agent running an SSIS package, and is unable to detect a file path!

John Esraelo-498130 wrote:
Thank you for the reply, Phil!
It was a minor adjustment on the networking folks, and it is fixed now.
thx
Two way street here... what was that "minor adjustment"?
--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:07 pm

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

Viewing 15 posts - 2,791 through 2,805 (of 59,067 total)