What is full form of XP ?
Answer Posted / amatjeet ray
XP means extended procedure where this procedure is made from dlls files which is written in c++ programing language.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Define outer join?
What is an execution plan? How would you view the execution plan?
Differentiate between delete and truncate.
What is sql server locking?
What is the difference between having clause and where clause in sql server?
Are resultset updatable?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
How adventureworkslt tables are related?
Difference between Sql server reporting services and Crystal reports?
How to list all schemas in a database?
What is data compression?
How to get the definition of a stored procedure back?
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
How to create a simple stored procedure in ms sql server?