what are the differences of where and if in SAS?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
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
Explain what partitioning is and what its benefit is.
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is the default fill factor value? : sql server DBA
i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???
what is the differnce between process and thread ?
Hot backup procedure?
how can you create a user-defined lock?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What the different types of replication and why are they used? : sql server DBA
Explain an ORA-01555