We are using SSIS ( SQL server 2008 ) for porting data from a DB2 database to another SQL server DB.
We have established OLE DB connetion...
Please let me know if there is a sp or table which will list out the table names and SQL included inside a DTS package
Hope you are doing fine.
We are using SQL server 2000 as the database server in our project.
We need a small clarification on revoking table...
Can anyone tell me how to restore differential backup?
Is there any special procdure other than normal restoration procedure?
Can anyone tell me how to make the SQL Mail running and how to check whether its running?
I would like to capture the historical backup and restoratin information of a database.Is there any SP or something else to find the above...
In our database lot of ununsed spaces in each table(Excluding Data size and index size).
Kindly let me know how to reduce the unused space?...
Is there anyway to reduce the disk i/o time while executing the query so that we can optimize the query execution plan?
Hi! Can anyone tell me how to add tables in data cache?
I read an article about data cache ih this site.
Can anyone tell me whether the DROPCLEANSTATUS will unpin the pinned tables?Due to tye pinned table swe are facing space issues.
Plz respond as...
I have used index tuning wizard to indentify the indexes that can be added to improve the performance.There are three tuning mode namely...
Can anyone clear my folllowing doubts?
1.I read a document regarding "Data Cache".In that document it has been mentioned that the data cache size...
Separate names with a comma.