Will count(column) include columns with null values in its count?

1093

Can you explain what is indexed view? How to create it?

904

What is equi join with example?

1130

Can a unique index be created on a column, which contains null?

919

List out the different types of locks available in sql server?

978

List the different normalization forms?

981

What command do we use to rename a db, a table and a column?

927

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1044

Explain powershell included in sql server 2008?

1055

How do you rename a table in sql server?

1025

How can you control the amount of free space in your index pages?

1057

how many bits ip address consist of? : Sql server database administration

899

How do you create an execution plan?

948

Explain activity monitors

1077

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

1041