Bulk Insert does not fire triggers by default. If you want a bulk insert to fire triggers, you have to specify.

From Books Online entry titled BULK INSERT:

FIRE_TRIGGERS

Specifies that any insert...

Exactly the same behaviour no matter where it's called from and no matter whether it's a procedure or ad-hoc code.

Yes, see if you can tune it, especially if you can...

Probably has nothing to do with the generation of the execution plan.

The first time a query runs, the data is read off disk into the data cache. Subsequent executions the...

Just means that SSMS has been disconnected. Could have been someone killing the connection, could have been SQL restarting.

What does this return?

select count(*)

FROM [LOAD_SCHED] as T1 inner join [Arch_LOAD] AS T2 on T2.[Arch_Key] = T1.[Live_Key]

select count(*) from LOAD_SCHED where Live_Key IS NULL

select count(*) from Arch_LOAD where Arch_Key IS...

https://www.simple-talk.com/sql/performance/the-default-trace-in-sql-server---the-power-of-performance-and-security-auditing/

arooj300 (6/10/2013)

---

Actually I don't know much about the Oracle.

Could you please tell me here deleted is the column name or table name, because in SQL SERVER we use inserted and...

No, it would not have shown up in the SQL error logs, it would have shown up in the default trace.

You can check the default trace for both data and log files, autogrow events are logged. The trace may have rolled over though, it only keeps 5 files of max...

That's Oracle code, not SQL Server. Maybe ask on an Oracle forum?

HowardW (6/10/2013)

---

You might also want to try deleting the tempDB files from the new location first and restarting the SQL Service, as you're not meant to copy tempDB when moving...

Check the VM settings to ensure that the VM really does have that much memory and doesn't just appear to have it. Make sure the VM host isn't stealing back...

Up to you. Do you see a value in having a SQL 2008...

https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

p.s. OS error 5 is Permission Denied. SQL doesn't have permissions to access the new location.

The 2012 exam has been out for about a year now, it's hardly a very new exam.