what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Can you explain about buffer cash and log cache in sql server?
What is the difference between char and varchar2 datatype in sql?
How to convert numeric expression data types by assignment operations?
Can we use trigger new in before insert?
Give a example to search fr a string in all stored procedure in sql server.
Difference between aggregate functions of sql?
Describe and explain about SQL native client?
Explain different types of locks in sql server.
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
How many types of the database links?
What is an sql server agent?
What are the types of subquery?
What are “lock” hints?
Explain indexes disadvantages?