One common cause for the ACT7 service to stop is when Windows Automatic Updates attempts to install an update to SQL. The Act7 instance is protected - the sql...

🙂

Hello ,From my opinion i have been used crystal reports and so happy with it, it gave me all facilities i need ,may be it sometime slow ,but nothing bad...

Solution:

Stagger the two collector jobs. E.g. collection_set_2_upload Server Activity and collection_set_3_upload Query Statistics to run a couple of minutes apart. Now, here is a catch! Don’t change the schedule for...

Sorry i forget to send you another important link

http://en.allexperts.com/q/MS-SQL-Server-1801/backup-restore.htm

same issue at link below

http://msdn.microsoft.com/en-us/library/ms175477.aspx

ok show link below

http://fawzi.wordpress.com/2010/12/04/upgrade-vmm-2008-r2-to-sp1/

Show same issue at below link

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/625d0475-30e5-4b45-95cc-6f49742569a0

See this link below

http://connect.microsoft.com/SQLServer/feedback/details/668354/no-statistics-management-options-fit-nightly-load-large-etl-system-scenario

ok see solution at below link

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/cdf5c2f8-3584-4b20-9848-9a175b4b18f4

Sorry but i forget to post you another important link of your issue

http://social.msdn.microsoft.com/Forums/br/transactsql/thread/844fdfbd-d7bc-41bb-9264-73c5c9285f04

Ok but i have more Prof way

The first option seems to take the shorter time to execute but I didn’t want to go through the effort of removing...

Thank you very much ,I did more search ,But i can't arrive any useful solutions ,

You save my time

Thanks

INSERT INTO destTable

SELECT Field1,Field2,Field3,...

FROM srcTable

WHERE NOT EXISTS(SELECT *

FROM destTable

...

To get a full reference here

http://www.hds.com/assets/pdf/best-practices-for-microsoft-sql-server-on-hitachi-universal-storage-platform-vm.pdf

very useful article same point ,It cannot do that but use simple mode to derease backup

http://stackoverflow.com/questions/571750/make-sql-server-faster-at-manipulating-data-turn-off-transaction-logging