That's because you have the condition on the SAP_Cust in the where clause, so are excluding NULLs (which are the non matching)

Alter your where clause to

WHERE dbo_SAP_CUST.KUNNR < '0000900000'

or...

can this be your Select query ... a little bit rewritten to avoid the row level count/sum selects ?

SELECT T.SectionID

, T.SectionOrder

...

another guess:

Wat's the relation for ScheduleUserID to the actual user and the actual test (s)he is conducting ?

Can a person take the same test more than once ?

You update query...

just my 2ct:

- your rows indeed aren't that wide, so this number of rows should be manageble.

- does your table have a clustering index (I guess it does, if you...

when removing a CLIX, the data will get rewritten to an 0 index (=heap).

Check out the structural changes of a heap vs a clustering index, and the effect this has...

- any chance on using SSIS to migrate your data from SQL to Oracle or the other way around ?

- if not, maybe a SQLCLR proc can help out. Also...

DON'T DO IT ! At least not with a trigger !

What if "the other instance" goes in maintenance, your "primary" instance will nolonger work because that trigger will fail !

If...

- disabling tcp\ip for that instance may get you to it !

- follow "Moving the MSDB database" in this KB-art : http://support.microsoft.com/kb/224071

- this may also help out: http://www.sqlservercentral.com/articles/Administration/2605/

2 x yes

Check out "The Art of XSD" by Jacob Sebastian in the Books section of SSC !

did you check Books online (BOL) topic "Starting and Restarting Services" ?

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

to early for homework 😉

it are table aliasses.

a pointing to syscolumns

b pointing to sysobjects

They are only valid for that specific sql statement.

Books online (bol) has more info. http://msdn.microsoft.com/en-us/library/ms187455%28SQL.90%29.aspx

btw I always...

You cannot have multiple logins pointing to dbo !

In most cases, we have 'sa' mapped to dbo.

sp_changedbowner @loginame = 'sa' ,@map = 'true'

User 'sa' is never used by applications and...

- what kind of trace file are you refering to ?

(If sqlserver trace files, which events does your trace capure ?)

- you could implement a DDL-trigger to keep track...

helpmhost (8/24/2009)

---

I tried again today. We have the auto-shrink property set as well, so today the Initial size of the data file was significantly less. I also added a second...