Answer / Rajesh Tejan

{"partitioned_views": "A partitioned view is a type of SQL Server view that spans multiple partitions within a table or indexed view. It allows for better performance by reducing the amount of data that needs to be read during queries.",n "distributed_partitioned_views": "A distributed partitioned view is a type of SQL Server view that spans multiple tables, each of which is stored on a different server in a distributed database. It allows for better performance by distributing the workload across multiple servers."}

How many full-text indexes can a table have?

1 Answers  

---

How use inner join in sql server?

1 Answers  

---

Does index slows down insert statements?

1 Answers  

---

what stored procedure would you use to view lock information? : Sql server administration

1 Answers  

---

What is database replication? What are the different types of replication you can set up in sql server?

1 Answers  

---

What is the difference between a function and a trigger?

1 Answers  

---

Write an sql query for deleting duplicate rows?

1 Answers  

---

I have cleared sbi clerk examination. I am Bachelor in computer application (BCA) graduate. so which type of question related bca in sbi clerk interviews. pls answers me at sejalvaghela@yahoo.co.in.. and also tell me which type of question asked in sbi clerk interview.

1 Answers  

---

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 Answers  

---

What are the instances when triggers are appropriate?

1 Answers  

---

What is the sql case statement used for? Explain with an example?

1 Answers  

---

What is bit datatype and what's the information that can be stored inside a bit column?

1 Answers  

---