Answer Posted / nikita

I agree with the above answer

What is difference between count (*) and count 1?

908

---

How do users use Report Builder with SQL Server data sources?

152

---

How can you stop stored procedures from recompiling?

878

---

Where is localdb stored?

921

---

How do I clean up sql server transaction log?

1045

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1079

---

What is cte (common table expression)?

1013

---

What is difference between inner join and full join?

1040

---

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., }

2317

---

What are .mdf files?

920

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

936

---

What are the types of resultset?

949

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1929

---

What is the difference between substr and charindex in the sql server?

1071

---

What are the advantages of the mirroring?

1058

---