Viewing 10 posts - 1 through 10 (of 10 total)
in case anyone hits this issue down the road, I found this article very useful.
https://ruslanmv.com/blog/How-to-connect-MySQL-Server-with-AWS-Glue
September 26, 2022 at 11:54 am
thanks Eddie, I've no issues paying for a subscription service, as long as it has a good quality library of lectures. I know when we had it at work a...
March 24, 2020 at 7:52 pm
Hi Phil, apologies, I thought I did. I guess you cant hear the voices in my head question from you - "Wouldn't this scenario (ie, PK exists, but other...
November 17, 2017 at 8:50 am
Thanks for all the replies gents.
The full flow of information is as follows :
1. Read the file in to initial load table, assign each file a batch ID
November 17, 2017 at 6:22 am
No date created or modified on the data. Primary key is combined from 2 columns but any of up to 80 columns could change driving the need for a new...
November 16, 2017 at 1:10 pm
dbcc shrinkfile / dbcc shrinkdatabase always work great for me when I need to frag an index
March 21, 2015 at 4:57 am
Hi just on the SSIS point I don't think the SSIS version has to match the SQL version. so maybe a check for multiple reg keys is in order for...
February 17, 2015 at 3:14 pm
January 26, 2015 at 6:01 pm
where I've seen this before is a sneaky maintenance plan where the DB is shrunk making redundant the lovely reindexing work carried out before the shrink.
What could be worth doing...
January 26, 2015 at 5:03 am
If you have space you could rebuild your indexes onto new files / file groups and simply drop the old files (bar the PRIMARY file) once the reindex has migrated...
January 26, 2015 at 4:49 am
Viewing 10 posts - 1 through 10 (of 10 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy