Explain how dts is used to extract, transform and consolidate data?
No Answer is Posted For this Question
Be the First to Post Answer
How to disconnect from a sql server using mssql_close()?
What are the differences between substr and charindex in sql server.
What is set nocount on and what is set nocount off?
Do you know what is a linked server in sql server?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
How to copy the tables, schema and views from one sql server to another?
What are rows and columns?
How do I open port 1433?
What is a livelock?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
How to create function with parameter in sql server?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?