Explain the steps needed to create a scheduled job?
What is subquery in sql?
Write a SQL command to insert and update only a particular field?
What is dbcc command in sql server?
How to create Clustered Primary Key to table?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
How to optimize stored procedure optimization?
Explain left outer join and right outer join?
Explain Active/Active and Active/Passive cluster configurations?
what is denormalization and when would you go for it? : Sql server database administration
What is a unique index?
please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on
What is the default isolation level of the sql server database?