Required software development freelancer for DBA Required job
Posted at - Oct 28, 2023
Toogit Instant Connect Enabled
1- Change settings of MS SQL server in a way that every newly created database has 'Auto Shrink' enabled. Then explain why it is a bad practice to enable'Auto Shrink' in production databases and what .
2- Imagine you have tableusersandsmartq_jobsinSQDB5database. Value insmartq_jobs.user_idequals tousers.id. Write sample SQL querythat will list all job titles (smartq_jobs.title) along with owner formusers.loginwheresmartq_jobs.cur_statushas value1and store it to local.
About the recuiterMember since Nov 11, 2022 Syarif Uddin from Scotland, United Kingdom