Answer Posted / harish sharma

Count(column_name) returns the number of records in the
table where the column value is not null for the particular
column.
Count(*) returns the number of all records in the table.
(including duplicates and those with nulls)

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

859

---

What are the new features of sql server 2012 reporting service?

125

---

Write a program to fetch first 10 records from a file?

975

---

Differentiate between ms sql server reporting services vs crystal reports?

857

---

How to add the custom code in Report?

120

---

Are connections to sql server encrypted?

950

---

Explain linked server in sql?

1162

---

What do you know about system database? : SQL Server Architecture

944

---

How do I install only the client tools of sql server 2000?

1001

---

How to create new tables with "select ... Into" statements in ms sql server?

939

---

Explain features of analysis services?

937

---

What is the default Port No on which SQL Server listens?

1082

---

What is the xml datatype?

1007

---

What causes index fragmentation?

952

---

How to rename databases in ms sql server?

1135

---