Fred, I think you may have seen this a) because importing entire tables, or b) importing very large subsets of tables, or c) because of something specific to your Oracle...

Ramesh, you are not correct.  Indexes on the underlying tables will be used, there is nothing in the view to "table scan."  You can see this for yourself in query...

I like the view idea better than explicitly referencing objects in other DBs. 

But to me the idea of having to grant my users rights to the underlying tables in...

I agree on smalldatetime for this.

And I would use GMT in your tables.  Does not matter what your server time or timezone is, as long as it is accurate.  You...

I enjoyed this article, good description of problem solving exercise.

But I don't think the title or any focus on isnull() is right. 

Assume some other function was used instead of isnull--maybe...

Checked history for CHECKDB on one of our 6.5 boxes.  DB is 25GB with about 9GB space free.  Not sure if that means CHECKDB only had to check 16GB or...

In addition to the problem with syntax of line 9 actually being wrong, I feel the answer choice uses poor wording:  "return value of the first execute statement" and "return value...

Much less performance impact than in any previous version of SQL Server. 

For me, I think the biggest impact is simply competition for I/O bandwidth.  I never see any blocking due to the...

Good stuff.  To para #3 I would add "and unscheduled jobs." 

I've been burned by someone else either removing or disabling the schedule of a regularly-scheduled job.  At first glance you...

Bad question, I think should be invalidated.

I followed steps exactly as they're stated, and get error as everyone else.  "Get an error & no backup is performed" was not one...

I don't have working example, but have done this before in TSQL. 

Use sp_OACreate 'SQLDMO.SQLServer', followed by sp_OAMethod with 'Connect' to attempt to connect to the remote/linked server.  If the...

Slow because pulling 1 row at a time (need to sift through working table 675k times), and then (I think) pulling the data into an external program (the ADO recordset?)...

In your scenario, there is no lock conversion.  S lock is obtained, then released when SELECT is done.  UPDATE brings its own new locks.  But there is no conversion, no deadlock...

S lock is released before the SET stmt. 

You can see this for yourself.  Within tran, at any point where you'd like to check what locks exist add this code:

exec...

doh! 

Need to wrap sum(...) or (select...) within isnull(), e.g.

select isnull((select  sum(Amount)

          from  AR_Transactions

         where  Customer_Number = @c), 0) +

        isnull((select sum(Amount)

          from  AR_Post_Dates

         where  Customer_Number = @c), 0)