Why and when do stored procedure recompile?
What is auditing in sql server?
When do you think a developer should use sql server-based cursors?
What is the basic difference between clustered and a non-clustered index?
How can you insert null values in a column while inserting the data?
2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID
how do u do Performance tunning ?
1 Answers Infodat Technologies, Satyam,
Can group functions be used in the order by clause in ms sql server?
Describe how to use linked server?
What is updatable resultset?
What is INTVAL( )and where we use Plz any body help me
How to use linked server?
what kind of lan types do you know? : Sql server database administration