Jeff Moden

Forum Replies Created

Viewing 15 posts - 181 through 195 (of 59,091 total)

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
Reply To: How to Obtain Call History of a Stored Procedure/UDF

Yes... that can be done and the methods have been available for quite a while. The problem is that it's arduous for the server to record information every time 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)

February 8, 2025 at 11:42 pm

#4533185
Reply To: Getting below error

sangameshms wrote:
Hi Johan,
This issue has been resolved by enabling TraceFlag 3057 on secondary logshipping server and reconfiguring the logshipping for each databases, now I can see all databases are 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 5, 2025 at 5:19 am

#4530110
Reply To: Throwing Iron at the Cloud and AI

Good article. Thanks for taking the time to write it.
I wonder when people will really reconsider what they've done. I was both shocked and tickled when I saw the articles...
--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 1, 2025 at 2:07 am

#4527202

Viewing 15 posts - 181 through 195 (of 59,091 total)