Interested to Buy Any Domain ? << Click Here >> for more details...
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
- 0 Answers
- 960 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is the difference between ‘having’ clause and a ‘where’ clause?
Define union, union all, minus, intersect?
What happens if we shrink log file in sql server?
Why we use functions in sql server?
How we create SQL Server 2005 Reporting Services ? Give me Sample
What is indexed views? plz explain with example?
What happens if null values are involved in bitwise operations?
Explain the types of indexes.
Explain external key management in sql server 2008
Does server sql treat char as a variable-length or fixed-length column?
How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?
-
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)
