We have data in a Source Server (SQL Server 2000), which is growing at the rate of 50MB/min. This should be transferred to destination server (SQL Server 2000)...
Hi Ramki My recommendation would be 1)DTS 2)Scripts with Linked server using DTS you would be able to clearly visualize the transformation and you can use...
Hi Satya Things i would suggest 1)Try to look around and attain info performance bottle necks (indexing,Tuning queries) 2)Keep a relatively big page file (not...
hi Vishnat, I dont think DTS will work with this much amount of data and either all the traditional methods like bcp.. I would recommend him to go for...
Hi Santosh In most Data migration projects i have seen DTS or BCP are the choices one ends up to DTS is an architecture built to handle good amount of data..it...
Hi Ramki Can you let me know the following so that I might be able to help you. 1. Is the database in both the domains the same? 2. Do you want all the data in...
Thanks guys. No, the databases are accross domains. There will be many other tables on the source. But we need to transfer data from One table only to the...
Hi, Im trying to create a index on a View, for this primary thing is i should have my view with SCHEMABINDING, so tried to drop the view and create the view...
SQL Server 2005: Enhanced Features and improved productivity with the new T-SQL Transact-SQL (T-SQL) functionality has been greatly enhanced with SQLServer...
Hi srinivas, sql to find duplicate records are follows select column1 from table1 group by column1 having count(column1 )>1 this will give u all those...
Hi All, I am Anirudh Pucha,Microsoft Student Ambassador. I have few Gmail Account Invitations with me. If any member of this worthy group needs a id for...
PUCHA
anipoori@...
Jul 5, 2005 6:31 pm
1110
Hi, I have a table with 70,000 records and which contains some child table like for each record in my parent table there is atleast 100 child record. Based on...
Come join the bandwagon to unleash the technology inside out.... Be a part of a live discussion from the convenience of your office/home and experience...
Yes I need Gmail Accountant PUCHA <anipoori@...> wrote: Hi All, I am Anirudh Pucha,Microsoft Student Ambassador. I have few Gmail Account Invitations...
Santosh, i would recommend writing a while loop/running thro a cursor and delete the records this way you would also reduced the no of blockers and would...
Thanks for help. K.Srinivas jeelani basha <basha_21_99@...> wrote: Hi srinivas, sql to find duplicate records are follows select column1 from table1 ...
 hai friends i am newly enterd into sql developing can any send good stuff on stored porcedures Thnaks dilip hai friends i am newly enterd into sql...
dilip kumar agnihotram
dilipkumar_a@...
Jul 6, 2005 2:55 pm
1119
Viswanath, I dont think this kind of solution can be implemented in a production server. The cursor will swallow all my resources. Veer, You told something abt...
Hey San, I made this Script in hurry but I am pretty sure it should work. Logic:- I am dividing teh whoel set of records to be deleted into segment of say 4...
Whether you are interested in database administration, database development, or business intelligence, you can access the E-Learning topic you want, when you...
Excellent suggestion .. it works!!.. ... UDF also should be Schema bound ! ... ('dbo.func_get_packinglist_flag') is not schema bound. Can you please make it...
Hi, As per ur suggestions i have recreated all udf with schema binding and and altered the view with schema binding now i created a unique clustered index on...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
