Viewing 15 posts - 151 through 165 (of 26,487 total)
Labor Day probably makes sense. Easier to put this out there and then change later, than keep extending it.
No update from RG, but quite a few people are...
May 31, 2020 at 1:21 am
I started working from home back in October 2019, so there really was no change for me when everyone else at work started doing the WFM thing. Of course a...
May 30, 2020 at 7:50 pm
edit: never mind, don't think it would work after all.
May 29, 2020 at 6:01 pm
I have to agree with Frederico, if your import process has been working without issues and then suddenly starts failing due to special characters, that says something changed at their...
May 12, 2020 at 11:30 pm
X, the re-write goes like this:
WITH CTE (Pull all the user ids who have logged in for last 12 months)
SELECT Client ID's WHERE Exists (select From CTE)
This would not...
May 12, 2020 at 7:54 pm
Here's the query. There's not any understanding on how the the language works, index usage (or lack of usage), and what these things do.
It works...
May 12, 2020 at 6:37 pm
Here's the query. There's not any understanding on how the the language works, index usage (or lack of usage), and what these things do.
It works in dev, why is...
May 12, 2020 at 4:51 pm
My problem is that I start forgetting what day it is. The only reason I know this is Sunday is that it is Mothers Day.
Been running into...
May 11, 2020 at 2:14 pm
Also, I have actually been working from home since October 2019.
May 10, 2020 at 5:25 pm
My problem is that I start forgetting what day it is. The only reason I know this is Sunday is that it is Mothers Day.
May 10, 2020 at 5:23 pm
Actually, you won't eliminate all the nulls unless some of the values in row 106 to 149 need to be duplicated in rows 2 to 105. There aren't enough rows...
May 8, 2020 at 6:37 am
Looking at the code you posted, correct, dynamic SQL was not required. I have found numerous instances of improper use of dynamic SQL by developers with my current employer. It...
May 7, 2020 at 3:57 pm
First, I would look at Server and Database Audits.
Second, why are you ignoring data changes from the application(s) user/login? Those should be audited as well as changes made outside the...
May 6, 2020 at 7:54 pm
This may seem really basic, but can you walk us through the steps you are using to restore the database including what backup file you are restoring, the command you...
May 6, 2020 at 3:52 pm
Lynn,
Thank you for the very kind words. If someone with your knowledge has claimed that I'm their mentor, then I'm truly humbled. To be honest, you're as much of...
May 5, 2020 at 1:56 am
Viewing 15 posts - 151 through 165 (of 26,487 total)