Hard to know, but it sounds like there is probably a trigger on the table, your security setting is working with it, your co-workers is not. But, honestly, that's a...

It sounds like you have a transaction rollback within one of the procedures, but no begin transaction statement. You have to either add a begin trans statement or remove the...

I would suggest you take a look at Michelle Ufford's scripts on index rebuilds and defrags[/url]. She has the most comprehensive and stable approach out there.

I don't completely understand what you're trying to do there, but yes, cursors are absolutely going to cause performance to slow down in most circumstances, regardless of whether or not...

On #3, if you change the data type on existing data, you face the possibility of data loss, which, for most businesses, is a bad thing. So when do this...

As much as I love people reading my book, I'm not sure that one will help.

What will happen when the CPU is maxed out? Processes start to wait for CPU...

SequelSurfer (1/11/2011)

---

sqlbuddy123 (1/10/2011)

---

MAX Degree of Parallelism is not recommended for OLTP Systems until and unless there are some very specific requirements. It cause 100% CPU utilization peaks for very short...

Restore time is about the same as the regular restore because most of that...

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...