It's possible it could take longer. It really depends on what the contention is. Did you look at the link on wait state monitoring? That should let you know what's...

That answers some of the questions. You still need to know what's causing the slowdown in the first place. If one or more tables are maxing out the CPU on...

Hi, I really need a job, can you fill out this questionaire for me?

I assume the place hiring him isn't smart enough to do a Google search on his name...

It really depends. It's possible you could do 10 at once, but are there relationships between these tables? That will certainly affect data loading. Maybe there's an issue with indexes...

mahesh_7474 (6/1/2009)

---

Hello gurus,

I am very new to SQL Server. I have attended the intreview for SQL server Junior developer. I can not find the answers for some of the questions...

Alvin Ramard (6/1/2009)

---

Grant Fritchey (6/1/2009)

---

Lynn Pettis (6/1/2009)

---

Grant Fritchey (6/1/2009)

---

Lynn Pettis (6/1/2009)

---

Great. I guess I can read them because their my articles, becuase I sure as heck didn't pay for...

Lynn Pettis (6/1/2009)

---

Grant Fritchey (6/1/2009)

---

Lynn Pettis (6/1/2009)

---

Great. I guess I can read them because their my articles, becuase I sure as heck didn't pay for a membership. Why...

Lynn Pettis (6/1/2009)

---

Great. I guess I can read them because their my articles, becuase I sure as heck didn't pay for a membership. Why pay for something I...

Assuming you have 'sa' privileges, you can query tempdb and see what's causing the growth.

Lynn Pettis (6/1/2009)

---

First, you have to be a full member (free membership appears to be good enough to read the articles).

Here is my article, The Dynamic Tally or Numbers Table.

Here...

Grant Fritchey (5/31/2009)

---

Roy Ernest (5/29/2009)

---

Is it the Dissecting SQL Server execution plans e-Book? If so then yes. I have it with me. And have started reading it.

I got it from...

And when you post the execution plan, please make it the actual execution plan. Thanks.

Let me rephrase the question to see if I understand.

Are you asking is it possible to put data into the foreign key that is not contained in the primary key...

It would increase the chances that I hire someone, without a doubt.

Roy Ernest (5/29/2009)

---

Is it the Dissecting SQL Server execution plans e-Book? If so then yes. I have it with me. And have started reading it.

I got it from SSC itself[/url]....