How to write a query with a right outer join in ms sql server?

960

How to override dml statements with triggers?

1273

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

1166

What is used to replicate sessions between instances in coldfusion clusters?

1101

What is tablix?

169

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1120

Is sql server is free?

1017

Tell me what is fill factor?

1012

List the different types of collation sensitivities in sql server?

1076

What command would you use to add a column to a table in sql server?

1356

Explain cross join or cartesian product in sql?

927

if no size is defined while creating the database, what size will the database have? : Sql server administration

1059

What are the advantages of using stored procedures in sql server?

1050

What are commit and rollback in sql?

1170

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

1009