So on Thursday I was asked to help analyze a batch process for a third-party product that originally took 2 hours and is now 19+ hour process that sometimes fails....

Andrew,

Here's my explanation for pluralization. Because the table doesn't contain a car it contains cars. The row is a car the table is a set of cars. ...

I call myself a Database Developer, but I've used programmer in the past. MY current title is Data Software Development Lead. If you can figure out what that...

Steve Jones - SSC Editor (3/18/2014)

---

jcrawf02 (3/18/2014)

---

Steve, I think you've just done this too much. Once you understand what you're trying to do, Conceptual and Logical blend quite a bit,...

Glad that seemed to help. I'm surprised no one else had anything to share about this.

Okay. First I'd try an update stats on the base table to make sure all the estimates are right.

Those aren't really duplicates based on the logic in the query....

To add images you can use the IFCode's (img tag or the Insert Image button at the top of the editor) if the image is something you can provide a...

GilaMonster (3/10/2014)

---

That's about what my commute is now, though it's closer...

Koen Verbeeck (3/10/2014)

---

Jack Corbett (3/10/2014)

---

Yeah, that's going to be a bit tough because of the lost time (90 minutes travel a day) and the loss of flexibility, but,...

The 2 things I'd look at when designing the SSRS folder structure is:

1. Making navigation easier for users

2. Making managing security easier for me.

In my experience those 2...

Gerard Silveira (3/9/2014)

---

Thanks for your reply Jack , so that would mean that SQL Server would have to actually do a row lookup to return the value for the Orderno,...

blasto_max (3/9/2014)

---

My SSRS 2008 service is started in windows services. It is running and uses the Local System as a logon, the same one I used during installation of BIDS....

Grant Fritchey (3/8/2014)

---

Jack Corbett (3/7/2014)

---

So for those of you who knew I was unemployed. I have an offer on the table. The only problem is that...

Can you post the execution plan and the table schema...

spaghettidba (3/9/2014)

---

Jack Corbett (3/7/2014)

---

So for those of you who knew I was unemployed. I have an offer on the table. The only problem is that it...