Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is the difference between drop table and truncate table?
What are the restraints imposed on the table design by a merge replication?
How to loop through returning rows?
When is update_statistics command used?
What is a not null constraint?
what is a self join? : Sql server database administration
Write a query to get all details of employee who has maximum salary from employee table
What are the operating modes in which database mirroring runs?
How to list all schemas in a database?
What do you understand by the data quality services in sql server?