what are different types of backups available in sql server? : Sql server database administration
902if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
952as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
870what type of index will get created after executing the above statement? : Sql server database administration
935explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
1021
how can you check the level of fragmentation on a table? : Sql server administration
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
Give me a SQL Query to find out the second largest company?
What is a coalesce function?
Define right outer join in sql server joins?
 Explain what is sql override for a source taLle in a mapping?
how many clustered indexes can be created on a table? : Sql server database administration
Why do you need a sql server?
What is query and its types?
Do you know what is openxml in sql server?
How to provide default values to stored procedure parameters?
why would you use sql agent? : Sql server database administration
How to grant a permission in ms sql server using "grant execute" statements?
What is the use of commit?
Does group by or order by come first?