Difference between report and query parameter. Why do we need different type of parameter?
what is cluster and nin-cluster index?
What stored by the msdb?
What are the differences between stored procedure and view in sql server?
Do you think BCNF is better than 2NF & 3NF? Why?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What happens if we shrink log file in sql server?
Why it is recommended to avoid referencing a floating point column in the where clause?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
How can you find out which stored procedures are recompiling?
What are the extra roles available in msdb? : sql server security
Creating Tables Using SELECT