Viewing 15 posts - 136 through 150 (of 59,065 total)
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...
February 17, 2025 at 12:43 am
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...
February 17, 2025 at 12:22 am
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...
February 16, 2025 at 6:12 am
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...
February 16, 2025 at 2:20 am
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...
February 12, 2025 at 11:54 pm
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...
February 12, 2025 at 11:42 pm
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"
February 9, 2025 at 10:01 pm
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...
February 9, 2025 at 5:09 am
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...
February 9, 2025 at 4:51 am
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...
February 9, 2025 at 4:37 am
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...
February 8, 2025 at 11:42 pm
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...
February 5, 2025 at 5:19 am
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...
February 1, 2025 at 2:07 am
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...
January 30, 2025 at 11:57 pm
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...
January 30, 2025 at 11:54 pm
Viewing 15 posts - 136 through 150 (of 59,065 total)