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

Enterprise or Express or Developer, those are all database servers. It sounds like you want the client tools. That's Management Studio and can be installed seperately from any of the...

So the estimated & actual rows are the same? Actual number of executions, rebinds, rewinds... There is more data to it than just the operators. Sorry, just trying to understand...

GilaMonster (5/29/2009)

Lurking a fair bit here at the moment, cause there's little better to do. Hence I'm catching this kinda stuff early.

Got no major projects that I'm busy with, just...

I do hate doing this, but those are both estimated plans. Can you post the actual plans?

As to why you're getting a seek or scan, if you look at the...

David Burrows (5/29/2009)

---

Grant Fritchey (5/28/2009)

---

Sorry to hear it. I love big dogs. We have an 80lb German...

Are there other columns in the table? Do you know what a foreign key (FK) is? Maybe this is a FK to another table where you can look up what...

You just schedule it to run every x number of minutes/hours, however often you or the the business have decided it needs to be run, and start it at 11:15...