Salut, am si eu cateva intrebari legate de SQL Server 2005:
1. Intr-un maintenance plan pentru "rebuild index" daca ti se cere sa:
a.the index must be rebuild using a fill factor of 90 -- trebuie ca la "Change free space per page percentage to" sa completezi 90 sau 10?
b.the fill factor must be applied to both the leaf level and the balanced tree of index -- trebuie sa bifezi "Pad index" sau "Ignore duplicate keys"?
c.while the maintenance plan is running all tables must be available for queries to be run -- trebuie bifat "Keep index online while reindexing"?
2. Daca ti se cere sa "Nested trigger execution is not allowed" este de ajuns ca la Server properties >>Advanced>>Allow triggers to fire others sa il pui pe False sau si la Database Properties>> Options>> Recursive triggers enabled sa fie pe True?
3. Daca ti se cere sa "Transaction Log must be set to be automatically truncated" trebuie sa pun recovery model pe Simple sau sa bifez Auto Shrink?
4. Daca zice ca "Transaction Log backups are part of the backup routine,each night SSIS package are run to import 5 milion rows of data" si ti se cere sa "you need to minimize the log space that is used by these import operations" ce trebuie facut? de pus recovery model pe "Bulk-logged" sau lasat recovery model pe Full, Auto Shrink pe True si Recursive Triggers Enabled pe True?
5. Am 2 servere....S1 si S2 si se cere cam asa:"you need to add S2 as a linked server on S1.Only the login named App1 should be able to access S2 through S1. a login named App2 with the password "password" must be used for the linked server connection to S2. you need to create the linked server by using the new linked server dialog box om S1" . Intrebarea este: In pagina New Linked Server dupa ce la General ii dau un nume lui Linked Server si aleg Server type: SQL Server la fereastra Security: ii dau Add si selectez pt Local Login: App1, la Remote Login ii scriu App2 la remote password:password....pe urma jos la "For a login not defined in the list above, connections will:" trebuie bifat Not be made sau Be made without using a security context?
Multumesc mult.