Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vani
MSDE: (Microsoft Desktop engine) sql server Express Edition
is the next version of MSDE.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the steps to use transact-sql cursor?
SQL Server Architecture ?
How to make a remote connection in a database?
Tell me what are the essential components of sql server service broker?
What is table valued function and scalar valued functions?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
What are the properties of the relational tables?
What are the new data types are introduced in sql 2000?
How do I clean up sql server transaction log?
What is lock escalation? : sql server database administration
What are the tables in sql?
How to replace the Query Result 'Null Value' with a text ?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
