performance of Insert with Partitioned View

From: TNL (le.nhan@freenet.de)
Date: 04/24/03 

From: "TNL" <le.nhan@freenet.de>
Date: Thu, 24 Apr 2003 05:42:30 +0200

I am trying to insert new Records in different Database on different Server
with a Partitioned View, but the perfomance is very bad.

The partitioned View: MyPVIEW
SELECT * FROM server1.myDB.myTable
UNION
SELECT * FROM server2.myDB.myTable
UNION
SELECT * FROM server3.myDB.myTable

The Job:
Insert into MyPVIEW
SELECT * FROM Temp

Temp is a Table on the local server, it hat about 300.000 records.

How can I improve the performance?

Relevant Pages

  • Re: performance of Insert with Partitioned View
    ... As documented in the SQL Server Books Online, partitioned views require UNION ALL's. ... > The partitioned View: MyPVIEW ... > Temp is a Table on the local server, ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot log out of RWW
    ... However when i was at the server, and tried typing in the FQDN, which points ... and rww would get stuck on the loading screens. ... So you need only give full control permission to Temp folder. ...
    (microsoft.public.windows.server.sbs)
  • Re: Swing migration Q?: problem joining new DC to temp domain
    ... Do not disconnect the temp DC from the old domain until you see a good ... should see on the new server at \\servername. ... I dig all old source server names out of dns. ... Check your SBS with the SBS Best Practices Analyzer ...
    (microsoft.public.windows.server.sbs)
  • Re: Win2k3 -> Win2k3
    ... where I use the temp server as a DC that replicate the AD objects. ... Windows 2003 domain to Windows 2003 domain using ADMT. ... 326480 How to use Active Directory Migration Tool version 2 to migrate from ...
    (microsoft.public.windows.server.migration)
  • Re: Server Shuts Down - HELP
    ... > SORRY GUYS - SERVER Down this morning. ... The room is warm (max temp went to 90' F) this was the first ... > lastest firmware from Compaq. ... >>> latest monitoring software from Compaq. ...
    (microsoft.public.windows.server.sbs)