Viewing 15 posts - 46 through 60 (of 1,249 total)
We were supposed to be back in the office from Monday but with the advice from the government changing from "go back to the office everybody" to " go back...
July 22, 2021 at 2:19 pm
YES!
"Nice to have: 2k years experience with DBCC TIMEWARP()."
And then sit back and see how many people actually respond. @=)
BWWWWWWAAAAA-HAAAAAA-HAAAAAA!!!!
That made my whole week! Thanks for the...
July 6, 2021 at 6:21 am
Spam is one thing but don't let anyone convince you to try scrapple. It's not "the same thing" it's not even "similar" 🙂
My father in-law made scrapple, and...
March 9, 2021 at 7:36 am
So you are just trying to make sure you don't load the same file twice. Maybe if you create another table of all the files you have loaded, insert...
March 5, 2021 at 3:47 pm
I think you need to add the file "key" -- to identity the unique file being loaded -- to the data file to distinguish between rows. That doesn't violate...
March 5, 2021 at 3:44 pm
Why are you worried about getting duplicates?
If you make sure the same file isn't loaded twice then would that solve your problem?
It's not the "duplicates" within a file that...
March 5, 2021 at 3:13 pm
I think you've got what I mean and that kind of query would be my first choice. But here's the rub, there will be rows in the main table like...
March 5, 2021 at 2:45 pm
January 15, 2021 at 10:10 am
So we have this third party shipping system that is...well...user hostile at best. To add insult to injury for the users the system has been suffering increased performance...
January 15, 2021 at 7:38 am
You can use sp_update_jobstep. Are you sure you can't do it in SSMS? If you open the properties tab of the step in question you can edit the Step...
December 24, 2020 at 7:26 am
My boss manually deleted the backlog in chunks on Friday and things appear to have been fine over the weekend. I'll know a bit more definitely when the...
December 15, 2020 at 7:29 am
Found out the other week, we're likely to be working from home to the end of June 2021...
So I splurged and bought myself a new, more adjustable desk chair...
December 15, 2020 at 7:14 am
Well, that took a tangent...
Thanks for your input gents. I'd done some poking about and I'd couldn't find what was calling the task anywhere. I did find the proc that...
December 14, 2020 at 7:47 am
Typical WYPIWYG, what you pay is what you get.
😎
The number of rows limitation just tells us that someone is using an old version of...
October 8, 2020 at 6:39 am
October 6, 2020 at 6:50 am
Viewing 15 posts - 46 through 60 (of 1,249 total)