Viewing 15 posts - 526 through 540 (of 8,760 total)
Damn! I've never had a collapsed lung but know other people that have. It's definitely NOT a cake walk. Glad it turned out ok in the end. Were...
January 10, 2020 at 4:07 pm
Good luck with that. Not sure third party tools make this better, but you're welcome to eval SQL Backup from Redgate if it might help
Yeah, I've...
January 10, 2020 at 3:43 pm
Do you have any favorite links on the subject of pulling rather than pushing?
Hmmmm ...
Nah thought I had one but no luck retrieving it.
I...
January 10, 2020 at 3:40 pm
Have you tried to run the query with "OPTION (MAXDOP 1) ?
😎
Looking at the execution plan, there are quite few opportunities for improvement, i.e. add indices to the #temp tables,...
January 10, 2020 at 12:51 pm
Getting kind of back on topic, has anyone tried the demo I provided?
I have, brilliant work my friend
😎
But as I'm ACE'phobic and I do not trust the...
January 10, 2020 at 12:24 pm
Getting kind of back on topic, has anyone tried the demo I provided?
I have, brilliant work my friend
😎
But as I'm ACE'phobic and I do not trust the black-box logic...
January 9, 2020 at 6:52 pm
Following up on Grant's fine post, can you share the actual execution plan?
😎
At the first glance, this looks like a tempdb related problem, without knowing what is actually going on,...
January 9, 2020 at 4:02 pm
Unzipping files is natively available in .NET, so there should be no need to install additional software.
See here for more info.
Just to be sure, my solution didn't...
January 8, 2020 at 5:23 pm
This is why I moved away from SSIS and ACE for spreadsheets with mixed data (ie numeric and alphanumeric) in the same...
January 8, 2020 at 5:12 pm
This is why I moved away from SSIS and ACE for spreadsheets with mixed data (ie numeric and alphanumeric) in the same column, unless...
January 8, 2020 at 4:51 pm
This is why I moved away from SSIS and ACE for spreadsheets with mixed data (ie numeric and alphanumeric) in the same column, unless I can...
January 8, 2020 at 4:36 pm
Thanks, Eirikur, I've had a look into that in the past, now that you mention it.
If anyone has a handy chunk of code, working something like this (with suitable...
January 8, 2020 at 4:22 pm
This is why I moved away from SSIS and ACE for spreadsheets with mixed data (ie numeric and alphanumeric) in the same column, unless I can guarantee the...
January 8, 2020 at 3:46 pm
Viewing 15 posts - 526 through 540 (of 8,760 total)