Can you explain about buffer cash and log cache in sql server?

998

Is BCNF better than 2NF & 3NF? Why?

1104

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1267

How do we know if any query is retrieving a large amount of data or very little data?

1032

What is the template in sql?

1029

Tell me can we use custom code in ssrs?

1054

How do I create a trace in sql server?

1090

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1049

What are the properties of the transactions?

1169

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

972

How to rebuild indexes with alter index ... Rebuild?

1181

Explain identity in sql server?

1055

Explain iaas, paas and saas?

92

How to convert a table data in XML format in sql server?

2594

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1166