Jeff Moden

Forum Replies Created

Viewing 15 posts - 151 through 165 (of 59,069 total)

Reply To: Are the posted questions getting worse?

DesNorton wrote:
Congratulations @jeff-moden Finally overtook the high priestess on the SSC overall leaderboard.
She did have a shedload of LIKEs. The "upgrade" on the site years ago hasn't helped much either. ...
--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)

February 19, 2025 at 8:43 pm

#4541531
Reply To: How Do You Change Data Type from uniqueidentifier

Ahr Aitch wrote:
In the ss below you can see that I have a table (dbo.clan.spouses) with a column (spousesID) that has a datatype of uniqueidentifier.
I assigned that value not knowing 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)

February 18, 2025 at 9:36 pm

#4540708
Reply To: blocking folks from using a linked server and plumbing one to specific dsn

Here's the section of the documentation that seems to apply here and it's in the form of step-by-step instructions. I do NOT know for sure if this will prevent DBAs...
--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)

February 17, 2025 at 1:12 am

#4539243
Reply To: Restore all Databases in a Directory

Hemantgiri S. Goswami wrote:
I had to modify the script (added a couple of columns in @FileList and @DbNameHeaders) and added some more logic to suit my needs.
This script works like charm 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)

February 17, 2025 at 1:02 am

#4539242
Reply To: Making Additions and Changes; Getting Error Preventing Them

As for not being able to see the column you added in the design view, it sounds like you did all the proper refreshes and so I have to ask,...
--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)

February 17, 2025 at 12:52 am

#4539231
Reply To: Making Additions and Changes; Getting Error Preventing Them

This is NOT a problem with code. It IS a setting in SSMS to prevent casual users from making changes using the Object Explorer. Unfortunately, it's an instance wide setting...
--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)

February 17, 2025 at 12:43 am

#4539230
Reply To: Or condition in where clause works differently in MS SQL comparing with Sybase

The error message is...
Msg 8114, Level 16, State 5, Line 12
Error converting data type varchar to numeric.
... and I'm surprised that this doesn't fail in Sybase but I don't...
--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)

February 17, 2025 at 12:22 am

#4539209
Reply To: Contracting DBA - Permissions for initial analysis

One of the first things you should do is to download Brent Ozar's first responder kit and run it.
Here's where you can get the kit...
https://www.brentozar.com/first-aid/
Here's where you can learn to...
--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)

February 16, 2025 at 6:12 am

#4538739
Reply To: Limits, Not Goals

Heh... it's funny how timely this article is, Grant.
One of the companies that I do a little work for has customers that must be responsible for the following meme...
--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)

February 16, 2025 at 2:20 am

#4538657
Reply To: Do You Folks Mind Beginners Here?

Ahr Aitch wrote:
I'm a retired IT guy in his 80s fighting boredom by trying to learn new things. SQL is the newest topic.
Am I in the right place or do you...
--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)

February 12, 2025 at 11:54 pm

#4536380
Reply To: ROWID in MS SQL

tizma wrote:
How to rewrite a query in MS SQL:
WHERE a.ROWID IN (SELECT rid
FROM ( SELECT ROWID rid,
row_number() OVER (PARTITION BY c.id ORDER BY c.id) rn
FROM details c
WHERE a.id = c.id
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)

February 12, 2025 at 11:42 pm

#4536379
Reply To: what is the difference between these two queries
The "JOIN" in the second query is in the WHERE clause as...
```
and (DFR.transaction_header_guid = ICT.transaction_header_guid)
```
It's also referred to as an "old style" or "Non-SANSI" "Equi-Join"
--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)
February 9, 2025 at 10:01 pm

#4533736
Reply To: Unreliable Narrators

David.Poole wrote:
Jeff Moden called it a Consensus Engine, which I thought was a brilliant description.
It's pretty much at peak hype in the hype cycle. It is genuinely useful, just 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)

February 9, 2025 at 5:09 am

#4533312
Reply To: Unreliable Narrators

For Perplexity.ai, it came so VERY close and, yet, it still failed. It did write corrected to go after this bit of narrative, though.
It's important to note that 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)

February 9, 2025 at 4:51 am

#4533296
Reply To: Unreliable Narrators

Eric M Russell wrote:
Regarding "unreliable narration", that just makes LLMs more human.
+1000! I've said that it has the "being human" part pretty much down pat. I very confidently provides the wrong answer...
--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)

February 9, 2025 at 4:37 am

#4533295

Viewing 15 posts - 151 through 165 (of 59,069 total)