Windows mode and Mixed Mode – SQL & Windows. To change authentication mode in SQL Server click Start, Programs, Microsoft SQL Server and click SQL Enterprise Manager to run SQL Enterprise Manager from the Microsoft SQL Server program group. Choose the server then from the Tools menu select SQL Server Configuration Properties, and choose the Security page.
Scheduled tasks let user automate processes that run on regular or predictable cycles. User can schedule administrative tasks, such as cube processing, to run during times of slow business activity. User can also determine the order in which tasks run by creating job steps within a SQL Server Agent job. E.g. back up database, Update Stats of Tables. Job steps give user control over flow of execution. If one job fails, user can configure SQL Server Agent to continue to run the remaining tasks or to stop execution.
Stored procedure can reduced network traffic and latency, boosting application performance. Stored procedure execution plans can be reused, staying cached in SQL Server’s memory, reducing server overhead. Stored procedures help promote code reuse. Stored procedures can encapsulate logic. You can change stored procedure code without affecting clients. Stored procedures provide better security to your data.
You should always select a weakness that you have been actively working to overcome. Always talk about a true weakness and also tell them how you are trying to overcome it.
UDF can be used in the SQL statements anywhere in the WHERE/HAVING/SELECT section where as Stored procedures cannot be. UDFs that return tables can be treated as another row-set. This can be used in Join’s with other tables. Inline UDF’s can be thought of as views that take parameters and can be used in Join’s and other Row-set operations. Functions are compiled and executed at run time. Stored procedures are stored in parsed and compiled format in the database. Functions cannot affect the state of the database which means we cannot perform insert,delete,update and create operations on the database. Stored … Click here to continue reading.