Answer Posted / saiteja
select ename,sal from emp
where sal=(select min(sal) from emp);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What are pages and extents? : SQL Server Architecture
Do you know what is bit data type and whats the information that can be stored inside a bit column?
Explain features of analysis services?
What is order of B+tree?
What is difference between join and natural join?
How to Check if table exists in sql server?
What do we need queues in sql service broker?
What is the chart in report?
What is trigger and different types of Triggers?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What is a primary index?
How to convert a unicode strings to non-unicode strings?
Explain what is analysis service repository?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?