How do you troubleshoot errors in a SQL Server Agent Job?
What are the different types of collation sensitivity in sql server?
Explain what is row_number function?
How to retrieve error messages using mssql_get_last_message()?
How to create a user name in a database?
Explain the basic concepts of SQL server architecture?
2 Answers College School Exams Tests,
What is the maximum row of a size?
What happens if strings are casted into wrong code pages in ms sql server?
how to trace the traffic hitting a sql server? : Sql server database administration
Explain log shipping and mention its advantages.
What are recommended options to be used while using db mirroring? : sql server database administration
Is there any difference between primary key and unique with the not null condition?
Diffrence between DTS vs SSIS