I've noticed 'problems' with the auto stats with large tables (+20 million rows) with clustered indexes on an increasing field.

I had a table a while back with DateAdded as...

If the record violates the pk constraint, any of the fk constraints or any of the check constraints, it won't be inserted and the trigger, if any, won't fire.

If the...

Doesn't looks too hard. One clarification please. Why didn't

appear in the thrid table?

What are...

Can you give the structure of the 2nd and 3rd tables, an example of input data and an example of your desired output please.

There's almost certainly a set-based solution for...

One minor correction

CREATE

Procedure select_Proc1

@Key3 varchar(10) = NULL

....

If you don't...

Whatever order the optimiser feels is best, based on it's knowledge of the data distribution statistics and the indexes that are available on the tables.

Whatever order the optimiser feels is best.

That said, it is considered beter to join in the from clause, rather than the where clause. for readability, if nothing else.

SELECT * FROM...

What you're asking doesn't make sense. Do youi want to add new records to tb1, or do you want to update fields of existing records in tb1 to a value...

This is one case where cursors are pretty much required.

There's no automatic syntax for executing a stored proc and taking params from a query result.

My pleasure. I'm glad it's fixed.

Weird. That's a little slow, but not close to causing a timeout. Even the default value is 5 min.

How long does it take from the web page?

No idea. The .net docs should tell you.

That's already a pretty high value. how long does that query take in QA?

Not the timeout in the config. Is something like cmd.Timeout in the code, after you create the  command, but before you execute it. Not a C# expert.

For blocking, run sp_who2...

Different databases, or different tables? Looks like the latter, assuming that it is.

This isn't tested, but it should be mostly right.

SELECT HH_ID, StudentID, MAX(Parent_ID) As ParentID

FROM ParentDatabase P INNER JOIN...

select

suser_sname()

Returns <Domain>\<Loginname>