Viewing 15 posts - 1 through 15 (of 1,235 total)
Duplicate post
April 25, 2024 at 6:39 am
I have the radio on when I'm working at home playing a classic rock station. As much as anything, it's because I don't like sitting in silence and...
April 25, 2024 at 6:38 am
I have the radio on when I'm working at home playing a classic rock station. As much as anything, it's because I don't like sitting in silence and it's a...
April 24, 2024 at 10:40 am
I see it rarely used. I'm sure someone does, but not many
We started "using" it last year. The customer insisted that we enabled it when we migrated and upgraded. ...
February 26, 2024 at 7:46 am
There doesn't appear to be an ALTER INDEX statement in the question. As it is, although I think I know what the answer should be, I don't think it's answerable.
January 10, 2024 at 8:20 am
Philosophically speaking, how can "I don't know" be a wrong answer?
I looked right through the correct answer in the documentation (not enough coffee yet) so I clicked the answer that...
December 8, 2023 at 7:41 am
Good question but there's a typo that will catch people out.
July 17, 2023 at 6:23 am
Have you looked at the query execution plan? There might be some clues as to what is causing the problem in there. What kind of data volumes are you dealing...
July 3, 2023 at 10:00 am
You've just gotta love people that give a super low rating to an article or QoTD without leaving a reason. 🙁 I thought this was a great question because...
April 14, 2023 at 7:19 am
I agree with Frederico. This
Databases with a compatibility level of 90, including backups taken on SQL Server 2005 (9.x), are automatically upgraded to a compatibility level of 100 when restored...
March 17, 2023 at 7:59 am
Jonathan AC Roberts wrote:I can't say I have ever used RIGHT JOIN. I think it is only in the language for completeness.
I use it a fair bit in real life.
Why would...
March 6, 2023 at 3:13 pm
This line in the WHERE clause
AND (hrxoreturn.returndate >= '2023-02-14 00:00:00' and hrxoreturn.returndate <= '2023-02-14 23:59:00')
changes your RIGHT JOIN to an INNER JOIN. If you move the line to your JOIN...
March 6, 2023 at 10:50 am
Have a look into the DATEPART function. That should point you in the right direction.
January 3, 2023 at 12:56 pm
I'm glad to hear that you've found a solution. As far as synchronising data during migrations, replication or log-shipping (one way or the other) are probably the most straightforward options. ...
September 14, 2022 at 1:56 pm
If you have access to the log files taken using Commvault, why can't you use some homegrown method to restore those to your target database? We use the OH scripts...
September 13, 2022 at 2:57 pm
Viewing 15 posts - 1 through 15 (of 1,235 total)