Bandwidth. Latency.

Imagine writing the lab...

That's a trigger, well the insert into another table part is.

For an insert to read from the client machine's registry, you will need to embed that functionality into the client...

That's not an error.

That's an informational message informing you that deleting logins does not delete the associated database users and to complete the delete you have to delete the database...

Wonderful, so not only do I have to fly to Europe when/if I need to write another lab, I need to take a laptop that can handle the Lync client...

Can't tell you which version or edition, not enough information. Review the documentation on MSDN, look at the features in each edition and version and see what you need and...

For spacial you need SQL 2008 or above (2008, 2008 R2 or 2012).

Can't tell you which version or edition, not enough information. Review the documentation on MSDN, look at the...

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

When FORCEPLAN is set to ON, the SQL Server query optimizer processes a join in the same order as...

Usually, but there are exceptions. Read up on what the differences are between the recovery models...

Lack of what?

Yes, low row estimation, whatever the cause, will cause very inefficient query plans. Operators that are good on smaller row counts are terrible on larger ones.

Usually, but there are exceptions. Read up on what the differences are between the recovery models...

Stores only ever have a single address and a single telephone...

Well, reading all of the data pages for the table.

Take a look at the differences between the recovery models and decide based on business requirements: http://www.sqlservercentral.com/articles/Administration/75461/

Also maybe Managing Transaction Logs[/url]

begin transaction

begin try

insert ...

delete ...

commit transaction

end try

begin catch

rollback transaction

end catch

68 pages is too small to worry about. The usual threshold that's mentioned is 1000 pages. Not a hard and fast number, just a guide