as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What is a data source file?
What you can do to delete a table without the delete trigger firing?
What are dml (data manipulation language) statements in ms sql server?
How to loop through the result set with @@fetch_status?
What is the boxing and unboxing concept in .net?
How to use subqueries with the exists operators in ms sql server?
What is @@error in sql?
Write a SQL query to delete a table?
What does this statement do @@rowcount?
How to create a user name in a database?
How to drop an existing table?
How do you handle datasets larger than 50 gb?
Explain the rules for designing files and file groups in sql server?
Explain optimistic and pessimistic concurrency?