how can u get last observation in an unknown dataset ?
Characterize join and name diverse sorts of joins?
How to Check if table exists in sql server?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is transactional replication?
Write a query to get all details of employee who has maximum salary from employee table
What is transaction server explicit transaction?
What are the types of database recovery models?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
Which system table contains information on constraints on all the tables created?
What is a print index?
What are user defined datatypes and when you should go for them?