how can you create a user-defined lock?
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? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Why would you use sql agent? : sql server DBA
Give the reasoning behind using an index.
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What are the different ways of moving data or databases between servers and databases in SQL Server?
what is ora 600?
What is the importance of a recovery model? : sql server DBA
what is rebuild index??
1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
what is the last version,the release date of that version and fix pack of ibm db2 udb?