Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
how to avoid cursors? : Sql server database administration
Explain the difference between cross join and full outer join?
Explain different types of collation sensitivity?
How to insert and update data into a table with "insert" and "update" statements?
How to start and end transact-sql statements?
Explain about remote stored procedure?
What is difference between after and before?
Are null values the same as that of zero or a blank space?
How to drop an existing table with "drop table" statements in ms sql server?
Difference between server.transfer and server.execute method?
What is pessimistic concurrency?
Explain the use of containers in ssis and also their types?