Answer Posted / gautam k panjikar

getdate()

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1848

---

Define right outer join in sql server joins?

515

---

What is database replication?

574

---

How to get the definition of a view out of the sql server?

502

---

Differentiate between a local and a global temporary table?

541

---

---

Can you tell me some of the common replication dmv's and their use? : sql server replication

533

---

What is the difference between update lock and exclusive lock?

492

---

Give me a SQL Query to find out the second largest company?

688

---

How do I find my localdb version?

491

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

532

---

How can we use ConnectorJ JDBC Driver with MS SQL?

566

---

How to backup encryption key ?

126

---

What is the function of sql server agent windows service?

535

---

What are the reporting services components?

92

---

What is equi join with example?

551

---