Answer Posted / vijayabhaskarreddy

view eassy to use , views used to work with part of the
tables.
** provides security for the data.

What are the purpose of Normalisation?

1050

---

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

1012

---

What are sparse columns?

1014

---

What do you understand by physical_only option in dbcc checkdb?

981

---

What is snapshot parameter in ssrs?

150

---

1 01 101 01010

2055

---

How to enter date and time literals in ms sql server?

1016

---

How to enable tcp/ip protocol on a sql server?

1162

---

what is an extended stored procedure? : Sql server database administration

1056

---

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1214

---

What kind of problems occurs if we do not implement proper locking strategy?

1404

---

Write a SQL query in order to merge two different columns into single column?

1036

---

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

977

---

What is the difference between osql and query analyzer?

997

---

What are exact numeric data types in ms sql server?

1077

---