explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
868what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
997what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
892how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
858there 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
870what is the difference between a primary key and a unique key? : Sql server database administration
959
How many servers can we create in a single subscription?
What is query processing?
What is efficiency data?
Do you know what is lock escalation?
What are different types of table joins?
explain the storage models of olap? : Sql server database administration
What are orphan records?
Does group by sort data?
What is the purpose of sql profiler in sql server?
Name three of the features managed by the surface area configuration tool? : sql server security
Can we call stored procedure in trigger?
How to override dml statements with triggers?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
How do you delete duplicate rows in sql server?
How to connect of datebase with sql express.?