How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

173

What are page splits? : SQL Server Architecture

158

Explain the truncate command?

136

what are the types of indexes? : Sql server database administration

164

What are the two authentication modes in sql server?

178

How to execute a sql statement using odbc_exec()?

157

Explain syntax for dropping triggers?

129

What is Federation and Federation Member?

26

How to use “drop” keyword in sql server and give an example?

215

How do you migrate data from mssql server to azure?

82

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

142

What is 'write-ahead log' in sql server 2000 ?

204

How many types of attribute relationships are there? : sql server analysis services, ssas

168

What are the steps you should follow to start sql server in single-user mode?

150

Write the queries for commands like Create Table, Delete table, Drop Table etc.

186