explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
938what is the system function to get current user's user id? : Sql server database administration
1048what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
1104what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
1000how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
958there 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
967what is the difference between a primary key and a unique key? : Sql server database administration
1041
Which is faster statement or preparedstatement?
How do I save a stored procedure in sql server?
Name few endpoints exposed by ssrs 2012?
What is not null constraint?
What is the difference between indexing and hashing?
What are the purposes of floor and sign functions?
Explain the steps to use transact-sql cursor?
What are different types of roles provided by ssrs?
What is the difference between char and varchar2 datatype in sql?
Can primary key be a foreign key?
Explain indexes disadvantages?
What are the different SQL Server Versions you have worked on?
What is bcnf normalization form?
can an order by clause be used in a creation of a view?
What are distinctive joins find as a part of sql?