Answer Posted / krishna sandeep

Advantage:

you can do row vise validation from a table

Disadvantage:

of example you are retrieving 100 row...
every single row you retrieve will hit the server as a
single select query so performance will be low.

What is the purpose of optimization?

994

---

What is the syntax for encrypting a column in SQL Server?

1119

---

Should you normalize audio?

941

---

Explain the concepts and capabilities of sql server?

972

---

explain how to create a new schema in a database? : Sql server database administration

1106

---

What is the usage of the sign function?

1110

---

What is buffer cash in sql server?

1152

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1083

---

Relational calculus is what type of language?

1034

---

What is the difference between char and varchar2 datatype in sql?

1065

---

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1903

---

What are different types of roles provided by ssrs?

150

---

Write down the syntax and an example for create, rename and delete index?

982

---

What is the purpose of the master database?

1122

---

What is system stored procedures?

1040

---