Interested to Buy Any Domain ? << Click Here >> for more details...
What is the best way to move n number of DTS package from
one SQLServer to another SQLServer?
- 1 Answers
- 4402 Views
- RBS, I also Faced
- E-Mail Answers
Answer / pratik
transfer data from sysdtspackages of msdb database to
another SQL Server
| Is This Answer Correct ? | 1 Yes | 2 No |
Can we passed multiple recordset(set of records) using a Stored Procedure
explain different types of jions with examples briefly?
How to execute stored procedure and set temp table in sql server?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
Why should we go for stored procedures? Why not direct queries?
What is the significance of master, tempdb and model databases?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
What is a coalesce function?
how many joins we can write if at all we have n no of tables
5 Answers Tanla Solutions, TS,
You 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?
What are the benefits of using stored procedures over sql statements?
-
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)
