What all db objects can be found in MSDB database of a SQL
Server instance?
Answers were Sorted based on User's Feedback
How is sql used in sql server?
Explain what is the purpose of sql profiler in sql server?
What are truncate options available in sql server? : sql server database administration
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is the security model used in sql server 2005?
Explain what are the basic functions for master, msdb, model, tempdb databases?
what is bit data type? and what are the information that can be stored inside a bit column?
Explain the types of indexes.
When do you create cluster and noncluster index?
Why Do you want to work in this company?
i want table name basis on column name.
Tell me what is use of except clause? How it differs from not in clause?