I would also double check the C# code that the execution order is as expected.

Someone more knowledgeable than I might be able to answer this, but I wonder...

Backing up the transaction log DOES not truncate the log. It frees up space on the log file for re-use. It basically says, "Now that these transactions have...

I don't know of anyway, outside of profiler/trace to tell when a table is accessed. In theory, you could use the DMV's to get the SQL Statements and parse...

Yes, the clustered index and all non-clustered indexes would be rebuilt when you use SSMS to insert a column in a specific position as it is a new table and...

Check out this link.

Oops, this is also a duplicate post and there are answers here sp please ignore this thread and go to this one.

Typically the number of tables in a database does not affect performance. It is the design of the database (indexes, etc...), query design, and number of users that typically...

Have you read the Database Mirroring section in Books on Line?

Have you tried setting up mirroring and encountered problems? If so, do you have specific questions?

Duplicate post, please post answers here. Please post once, duplicate posts fragment replies.

Duplicate post, please post answers here. Please post once, duplicate posts fragment replies.

Duplicate post, please post answers here. Please post once, duplicate posts fragment replies.

Are you using Reporting Services to display the report?

Can you post sample data and expected results as suggested in the links in my signature line?

Duplicate post and in the wrong forum. Please post answers here.

Ahh, thanks Jacek for catching my omission. I only looked at the first "pair" and they were tied by date so I assumed the rest were as well. ...

Derek Dongray (3/18/2009)

---

Chris Morris (3/18/2009)

---

Grant Fritchey (3/18/2009)

---

I'm going to hell for this one, I just know it.

I was checking up on the status of what I think is a bug...