What is the purpose of linked server configuration in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)
What kind of problems occurs if we do not implement proper locking strategy?
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
What are the mathematical functions supported by sql server 2005?
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.
What is the synonym of join?
What is a view in sql?
Does the unique constraint create an index?
Explain acid?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
What are the steps need to be take improve the speed of a SQLDATA Server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)