Answer Posted / anamika

How to know the size of any database:
Syntax:
sp_helpdb 'tempdb'

db_size of temp db 38.56 MB.

How efficient you are in oracle and SQL server?

1150

---

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169

---

What is 2nf normalization form?

1135

---

how to determine the service pack currently installed on sql server? : Sql server database administration

961

---

What are the advantages of sql azure?

140

---

what are isolation levels? : Sql server database administration

988

---

What are the diifferences between the ms sql server vs mysql?

1172

---

How to drop an existing user defined function in ms sql server?

1023

---

What is candidate key with example?

975

---

How to replace given values with null using nullif()?

986

---

What is meant by dirty read?

993

---

Define synonym?

1169

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

952

---

What is equi join with example?

1119

---

How do you create a clustered index?

1050

---