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?
What is the maximum size of a dimension? : sql server analysis services, ssas
Can primary key be null?
What is function of master database?
How to filter records of table in SQL SERVER?
Introduction of rollup clause using sum and group by clause?
How to configure odbc dsn with different port numbers?
Is port 1433 secure?
How to create a user to access a database in ms sql server using "create user" statements?
Explain something about security and SQL Azure?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
How you can add messages to the nt event log from within a stored procedure?
what information is maintained within the msdb database? : Sql server administration
Explain Capacity planning to create a database? and how to monitor it?
Can you explain the disadvantages/limitation of the cursor?