Don't think there should be a problem. Just make sure that your server has enough processing power, memory and disks. You can also do CPU affinity settings in case you have certain high processor intensive databases. Prateek. [HCL Technologies Ltd] "Remember: 80% of bugs are just undocumented features waiting to be discovered!"
2003-07-25
Hi Ritch, quote: If people were cheating to achieve something I think it would be a different matter entirely, but how much are they going to truly learn by copying the answers. And at the end of the day thats what it is all about, learning. nothing? How much people do really want to learn? […]
2003-07-25
1 reads
Is there any way to use the update in this context. Like...existing rowid should be updated. non-existing rowid should be inserted. update b Set b.column1=a.column1,b.column2=a.column2,b.column3=a.column3 from table2 as b right join table1 as a on (a.rowid = b.rowid) when I run this it is updating only one record. Whereas it should insert the non-existing record […]
2003-07-24
1 reads
Assuming the cust_id = dup_code, why not do a simple select count of all matching records between the two tables SELECT @Count = COUNT(t1.*) FROM unique_cust t1 INNER JOIN unique_cust t2 ON t1.cust_id = t2.cust_id
2003-07-23
I would bcp header data to one file, bcp the data to another and concatenate the two.
2003-07-22
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-21
Most likely DTS, though custom scripts will work. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-07-18
1 reads
Sure SET @MailMsg = '78 load ran correctly' -- Actually this is built dynamically in a --case satement, and is only one of the --possible results for the mail message EXEC master.dbo.xp_sendmail @recipients = 'TomN.@myco.com; TomS@myco.com', @message = @MailMsg , @copy_recipients = 'JWT@myco.com' @subject = 'Daily 78 Load' Edited by - jwt on 07/16/2003 1:44:38 […]
2003-07-16
Have to agree to use Stored Procedures if possible. In my opinion, Maintainability is not necessarily an advantage of Stored procedures. You might / will be distributing 'Business Logic' over two tiers, which should be avoided, if possible. But the gain in performance and limitation of network traffic is an obvious advantage. It is also […]
2003-07-15
1 reads
2003-07-10
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
By DataOnWheels
DIVERSIFY! We devote a lot of time to mastering the technology that we are...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers