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?????
2 6722I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?
1 3954Post New DB Administration Questions
how can you enable flashback feature?
Explain about your sql server dba experience? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Query processing is slow(eg select query)how will u solve that
internal architecture
What are the recovery models for a database? : sql server DBA
what is the use of ocr?
how can you initialize log miner?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
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
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you record information about current session?
what are the types of connection load-balancing?
How can you control the amount of free space in your index pages? : sql server DBA
how can a session indicate its interest in receiving alerts?