Explain indexed views and partitioned view with their syntax.

0 Answers  

---

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 Answers  

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  

---

What is the purpose of forms?

0 Answers  

---

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

---

What are the different types of upgrades that can be performed in sql server?

0 Answers  

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

What is tempdb database? : SQL Server Architecture

0 Answers  

---

How will you decide the active and passive nodes?

0 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

0 Answers  

---

How to swap the data of two columns in a table. both the columns containing varchar values.

9 Answers  

---