How to create an index on a view?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is the difference between count () and rowcount ()?

0 Answers  


How to define the name and server for a new dsn?

0 Answers  


What is the recommended total size of your memory optimized tables?

0 Answers  


What is entity data services?

0 Answers  


What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

0 Answers  






What is query and its types?

0 Answers  


What are the properties of the transaction?

0 Answers  


What is the difference Between Sql-server 2000 & 2005

3 Answers   Value Labs, Wipro,


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

0 Answers   CSC, IBM,


How will u get 5 years back record?

5 Answers  


how can we know that how many users are connected in perticuler server??????

2 Answers  


Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 Answers  


Categories