John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
990Write a sql query to sort on different column name according to the parameters passed in the function?
964Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
1193You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
1061
Explain ranking functions?
where the connection string store in the database
What is exporting utility?
Describe different Processing Modes offered by SSRS?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
How to use the inserted and deleted pseudo tables?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
Explain syntax for dropping triggers?
What is onf in normalization form?
What are the diifferences between the ms sql server vs mysql?
‘Order by’ is not allowed in a view how can you sort information from a view?
What is clustered index
Why use “pivot” in sql server?
Explain how many normalization forms?
Do you know spatial data types - geometry and geography in sql server 2008?