Can you explain different types of locks in sql server?
Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC
how to trace the traffic hitting a sql server? : Sql server database administration
What is xdr?
what operator performs pattern matching?
Difference between Cluster and Non-cluster index?
32 Answers Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,
What is the optimization being performed in oracle and SQL Server?
What is clustered vs nonclustered index?
What is field with example?
How do I make a resultset scrollable?
 Explain what is sql override for a source taLle in a mapping?
Explain what role entity and relationship play in an ER diagram.
A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?