Viewing 15 posts - 526 through 540 (of 59,066 total)
I have to ask... are the middle two letters in the author name indicative of what wrote this article?
May 30, 2024 at 3:30 am
ALTER DATABASE MyDB SET OFFLINE WITH ROLLBACK IMMEDIATE;
RESTORE DATABASE MyDB FROM DISK = 'D:\Backup\MyDB.bak' WITH REPLACE, STATS = 10;Restore command
Interesting. I've never using the SET OFFLINE...
May 30, 2024 at 3:02 am
Please obfuscate the database name and then post the exact command(s) you're using to do the restore.
May 29, 2024 at 11:54 pm
Quick interuption: 5+ gallons of blueberries from my bushes. First picking. And oh, do they taste good.
More berries to come in a few weeks, possibly just as many.
What to...
May 29, 2024 at 11:49 pm
Here's just one of the many proofs... Both the direct conversion from DATETIME2 to DATETIME and the faulty answer above produce the "silent failures" that I'm...
May 27, 2024 at 11:26 pm
Just out of interest, what is the method you use for converting a DATETIME2 value to a DATETIME?
I thought I had a good one but then found a "silent...
May 27, 2024 at 6:00 pm
Yes, well ChatGPT generates its responses one word at a time, using each preceding word and the context of the conversation, including its own partially completed sentences, to predict...
May 27, 2024 at 3:30 pm
Heh... ask it how to convert a DATETIME2 value to a DATETIME value in SQL Server. 😉
I haven't got Copilot, but I thought I'd try it on ChatGPT
May 27, 2024 at 3:07 pm
Heh... ask it how to convert a DATETIME2 value to a DATETIME value in SQL Server. 😉
May 27, 2024 at 3:20 am
.
I don't see any other big bugs...
Post links that go to the wrong post because spam notifications are no longer considered to be posts and are not counted in...
May 27, 2024 at 2:55 am
All of the other folks have brought up great points on this thread and there's really nothing to add. To emphasize, though...
May 24, 2024 at 12:13 am
What I'm seriously miffed about is that no one at Redgate seems aware nor gives a damn about these forums. Apparently even Steve has zero pull with them. Sorry...
May 22, 2024 at 11:00 pm
What I'm seriously miffed about is that no one at Redgate seems aware nor gives a damn about these forums. Apparently even Steve has zero pull with them.
Two short paragraphs...
May 22, 2024 at 10:58 pm
Obvious question, why does this person have the ability to do this in prod in the first place, kill this and you resolve 99.9% of the issues
Put delete triggers...
May 22, 2024 at 10:37 pm
From the article:
"Life rewards action, not intelligence. Many brilliant people talk themselves out of getting started, and being smart doesn't help very much without the courage to act. You can't...
May 21, 2024 at 6:29 pm
Viewing 15 posts - 526 through 540 (of 59,066 total)