Jeff Moden

Forum Replies Created

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

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
Reply To: Change all occurances of one field in DB

frederico_fonseca wrote:
the best, and probably correct, way is to use your visual studio (or vs code) solution (you do have one don't you!!!) and its schema compare.
while there are 2...
--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)

January 30, 2025 at 11:57 pm

#4526450
Reply To: T-SQL Script for Monitoring Database Size in SQL Server

chuckh1958 wrote:
This does not show database sizes but rather individual database file sizes. To do what I think you want it to do - show total space used per database, change...
--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)

January 30, 2025 at 11:54 pm

#4526449
Reply To: Change all occurances of one field in DB

You will need to do the rename the column inside of every coded object, as well. The textual content is located in sys.sql_modules by object ID. Obviously, you're going 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)

January 30, 2025 at 10:00 pm

#4526401

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