Interested to Buy Any Domain ? << Click Here >> for more details...
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
900what is the system function to get current user's user id? : Sql server database administration
1000what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
1049what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
945how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
907there 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
921what is the difference between a primary key and a unique key? : Sql server database administration
997
Explain about Joins?
What is an example of a foreign key?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What is a trigger what are the advantages of trigger?
How we create SQL Server 2005 Reporting Services ? Give me Sample
What is de-normalization and what are some of the examples of it?
What the class forname () does?
How can you control the amount of free space in your index pages?
What is the difference between SQL notification and SQL invalidation?
why would you call update statistics? : Sql server database administration
Define clusters?
how would you troubleshoot blocking? : Sql server database administration
What is indexed view? How to create it?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What factors you will consider calculating the storage requirement for that view?
