Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

1001

What is the maximum size of a dimension? : sql server analysis services, ssas

1086

Can primary key be null?

982

What is function of master database?

116

How to filter records of table in SQL SERVER?

1132

Introduction of rollup clause using sum and group by clause?

1011

How to configure odbc dsn with different port numbers?

1151

Is port 1433 secure?

1038

How to create a user to access a database in ms sql server using "create user" statements?

996

Explain something about security and SQL Azure?

134

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

995

How you can add messages to the nt event log from within a stored procedure?

1134

what information is maintained within the msdb database? : Sql server administration

1017

Explain Capacity planning to create a database? and how to monitor it?

4243

Can you explain the disadvantages/limitation of the cursor?

1054