How to delete duplicate rows from table except one?
What is data mart? : sql server analysis services, ssas
What is the difference between online clustering and Offline clustering?
Define indexes?
What is indexed view?
What are the new features in SQL Server 2005?
What is outer join in sql server joins?
How many types of functions are there in sql server?
How can I create a report based on a query? : sql server management studio
How to get last system shutdown time in Sql server when restarted system?
How to select true false based on column value in sql server?
whate is advantages of sql server 2000
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.