You mean the certification that no longer exists?

Seconding Grant. Architect of any type requires years of experience, of working in the field and then learning the architecture side of things.

anoop.mig29 (9/4/2013)

---

suppose i set max server memory to certain value , enabled lock pages in memory is enabled, now suppose sql server requires memory more then that what i...

That's a meta-data only operation. Because varchar is variable-length, nothing in the rows has to change as a result of that.

No and no.

2. Having 2 instances with mirrored...

Please take a read through this article on how to manage transaction logs - http://www.sqlservercentral.com/articles/Administration/64582/

Restore you take a database backup and SQL creates a database with database files from that backup

Attach you just have the database files (no backup) and SQL creates the database...

I don't.

I have about 8 years experience designing, developing and tuning SQL Server. 0...

I do hope you're joking. If not, that'll be two...

Data files are striped. Log files are used sequentially (hence why there is NO performance benefit from multiple log files)

Having fun preaching there Chris? :hehe:

Unrelated to the errors, but be very careful using a table variable. The performance impact is often not acceptable.

Why? What's the purpose of the temp table and how does it get populated?

I'd add an artificial primary key and put a unique constraint on the unique set of columns.

Unlikely. Synchronous...