Explain indexed views and partitioned view with their syntax.


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

Post New Answer

More SQL Server Interview Questions

How to create hyperlink from returned sql query ?

0 Answers   MCN Solutions,


Tell me in brief how sql server enhances scalability of the database system?

0 Answers  


What do you mean by an execution plan?

0 Answers  


What you can do to delete a table without the delete trigger firing?

0 Answers  


statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 Answers  






what is curser.

9 Answers  


Tell me what do we need queues in sql service broker?

0 Answers  


What is sqlservr.exe - process - sql server (sqlex?press)?

0 Answers  


What is recompile sql server?

0 Answers  


What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,


can a table be moved to different filegroup? : Sql server administration

0 Answers  


How to copy data from one table to another table?

0 Answers  


Categories