JMSM (1/10/2011)

---

Hello again,

I'm really but really sorry, but i'm completely lost and hope that anyone explain me what should i do like if i was a donkey :crying:

Sorry but i...

Craig Farrell (1/10/2011)

---

Grant Fritchey (1/10/2011)

---

This results in a merge join on just a few records. From what I can see, I'd try an index on the PastExperience table on the...

Blocking is caused when a process takes an extended lock on a resource, a page, row, table, database, that other processes needs. The other processes are blocked until the resources...

True. Something like Red Gate's Virtual Restore allows you to access the data on a backup directly without even restoring the database.

JMSM (1/10/2011)

---

Hello again,

I've attached the execution plan and the code of both views, the oldest and the new one.

I've change yet the column names, and the tablename on both views.

Thanks...

You do know that hiring managers can perform searches for people's names. If this comes up on a search, you're guaranteed to not get the job because no one is...

It depends so much on what you have available. There are lots of things you can do, but without knowing what you have, what the situation is... There's no way...

hemanth T (1/9/2011)

---

when i tried to execute chained state of stored procedures.

system encountered exception error no:266

with following message.

Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is...

They had to have been referring to ad hoc, client side code. A parameterized query or a stored procedure are basically the same thing, so you're already on the right...

Who knows. Could be anything. Maybe it's a nested transaction and starting another one causes an error. I'd just place it inside the TRY statement, just in case. One example,...

I wouldn't necessarily jump off a building yet. There is specialization, and this product is so absolutely huge, that no one is going to know everything. But you can be...

If you perform the update within a transaction, other users should not be able to access.

Are you doing this to create an identification generation engine? Or, to put it another...

I agree with what everyone else has said. I think they've caught the obvious stuff. Now, to keep going, can you post the execution plan from the query, preferably after...

I'm not seeing anything radically different either.

The only exception is, I'd move the BEGIN TRAN inside the BEGIN TRY statement so that if there are errors on the initiation of...

OK. I've narrowed it down a bit. It's not a limit on number, it's specific feeds from SSC. The 2008 backup forum doesn't work, but the General & TSQL ones...