What is raid, and how it can influence database performance?

1097

How will you make an attribute not process? : sql server analysis services, ssas

1159

What is attribute hierarchy? : sql server analysis services, ssas

1063

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

998

List the advantages of using stored procedures?

1106

What is the native system stored procedure to execute a command against all databases?

1085

How to declare and use cursor variables?

1252

What do you mean by a Composite primary key?

1187

how you can get the list of largest tables in a database? : Sql server administration

1100

Explain the properties of subqueries in sql server?

1139

How can a user-defined datatype be created?

1036

How can you insert null values in a column while inserting the data?

1343

What is an execution plan?

1235

How to create a testing table with test data in ms sql server?

1143

What is the default sql server instance name?

1086