How can we help you today? How can we help you today?
rmg1
Activity overview Badges (0) Posts (0) Comments (8)

Comments

Sort by recent activity
Thanks Dan. Is there any way for me to help this gain some momentum? Regards Richard / comments
  1. Community
  2. SQL Prompt
  3. Align = in MERGE statement
Thanks Dan.Is there any way for me to help this gain some momentum?RegardsRichard
0 votes
[image] Hi Dan Found the option to attach a screenshot. This is what we'd like to see. Thanks Richard / comments
  1. Community
  2. SQL Prompt
  3. Align = in MERGE statement
Hi DanFound the option to attach a screenshot.This is what we'd like to see.ThanksRichard
0 votes
Hi Dan This is what we currently get:- WHEN MATCHED THEN UPDATE SET TARGET.fkPatientLocalID= SOURCE.PatientLocalID ,TARGET.fkStaffLocalID= SOURCE.StaffLocalID ,TARGET.EpisodeStartDateTime= SOURCE.EpisodeStartDateTime ,TARGET.EpisodeEndDateTime= SOURCE.EpisodeEndDateTime ,TARGET.MainSpecialtyLocalCode= SOURCE.MainSpecialtyLocalCode ,TARGET.MainSpecialtyLocalDescription= SOURCE.MainSpecialtyLocalDescription ,TARGET.MainSpecialtyNationalCode= SOURCE.MainSpecialtyNationalCode ,TARGET.MainSpecialtyNationalDescription= SOURCE.MainSpecialtyNationalDescription ,TARGET.TreatmentFunctionLocalCode= SOURCE.TreatmentFunctionLocalCode ,TARGET.TreatmentFunctionLocalDescription= SOURCE.TreatmentFunctionLocalDescription ,TARGET.TreatmentFunctionNationalCode= SOURCE.TreatmentFunctionNationalCode ,TARGET.TreatmentFunctionNationalDescription= SOURCE.TreatmentFunctionNationalDescription ,TARGET.IsDeleted= SOURCE.IsDeleted ,TARGET.SYSDateLastUpdated= @Today This is what we'd like to see:-   WHEN MATCHED THEN UPDATE SET TARGET.fkPatientLocalID                         = SOURCE.PatientLocalID ,TARGET.fkStaffLocalID                          = SOURCE.StaffLocalID ,TARGET.EpisodeStartDateTime                    = SOURCE.EpisodeStartDateTime ,TARGET.EpisodeEndDateTime                      = SOURCE.EpisodeEndDateTime ,TARGET.MainSpecialtyLocalCode                  = SOURCE.MainSpecialtyLocalCode ,TARGET.MainSpecialtyLocalDescription           = SOURCE.MainSpecialtyLocalDescription ,TARGET.MainSpecialtyNationalCode               = SOURCE.MainSpecialtyNationalCode ,TARGET.MainSpecialtyNationalDescription        = SOURCE.MainSpecialtyNationalDescription ,TARGET.TreatmentFunctionLocalCode              = SOURCE.TreatmentFunctionLocalCode ,TARGET.TreatmentFunctionLocalDescription       = SOURCE.TreatmentFunctionLocalDescription ,TARGET.TreatmentFunctionNationalCode           = SOURCE.TreatmentFunctionNationalCode ,TARGET.TreatmentFunctionNationalDescription    = SOURCE.TreatmentFunctionNationalDescription ,TARGET.IsDeleted                                = SOURCE.IsDeleted ,TARGET.SYSDateLastUpdated                      = @Today Hopefully the above makes sense. If not, I can post screenshots if that is an option. Thanks Richard / comments
  1. Community
  2. SQL Prompt
  3. Align = in MERGE statement
Hi DanThis is what we currently get:-WHEN MATCHED THENUPDATESETTARGET.fkPatientLocalID= SOURCE.PatientLocalID,TARGET.fkStaffLocalID= SOURCE.StaffLocalID,TARGET.EpisodeStartDateTime= SOURCE.EpisodeS...
0 votes
Thanks for the heads-up. As far as I know, we have a maintenance job on the original server which takes care of index rebuilds, etc. As we currently use mirroring/snapshotting to transfer the data to a single server, I don't think that will be an issue. From what's been put on here, I think the plan will be:- Create backup of original database(s) Make image(s) from backup Clone image(s) to appropriate server(s) as per my original post. / comments
  1. Community
  2. SQL Clone
  3. SQL Clone for static databases
Thanks for the heads-up.As far as I know, we have a maintenance job on the original server which takes care of index rebuilds, etc.As we currently use mirroring/snapshotting to transfer the data to...
0 votes
One final question..... Can we put the backup/image files anywhere or would we need to keep them on the same server as the SQL instance? I'm thinking of putting them onto one our fileservers (there's more room) in a secure folder but not sure that's possible. / comments
  1. Community
  2. SQL Clone
  3. SQL Clone for static databases
One final question.....Can we put the backup/image files anywhere or would we need to keep them on the same server as the SQL instance?I'm thinking of putting them onto one our fileservers (there's...
0 votes
Thanks for that. Can you advise on the size of the clones as well please? / comments
  1. Community
  2. SQL Clone
  3. SQL Clone for static databases
Thanks for that.Can you advise on the size of the clones as well please?
0 votes
Brilliant, thanks for that. So, as we will only be reading from the clones, they should stay at 50MB each. / comments
  1. Community
  2. SQL Clone
  3. SQL Clone for static databases
Brilliant, thanks for that.So, as we will only be reading from the clones, they should stay at 50MB each.
0 votes
Thanks for that, I'll pass it to our technical server team. Just out of curiosity, can you tell me how much room the following would take up when cloned:- Database A - 580GB Database B - 651GB Database C - 38GB Database D - 22GB We would need a single image of each with one clone of each as per my initial question. I'm not sure if it makes a difference, but we would be compressing the backups (SQLServer 2012 Enterprise) using the built-in compression algorithm. Regards Richard / comments
  1. Community
  2. SQL Clone
  3. SQL Clone for static databases
Thanks for that, I'll pass it to our technical server team.Just out of curiosity, can you tell me how much room the following would take up when cloned:-Database A - 580GBDatabase B - 651GBDatabase...
0 votes
Total activity
10
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2