Does the SSIS package do anything besides insert the data? Maybe the statistics are getting updated as well. If not, maybe they need to be.

Just a note, right in the upper right hand part of the screen on this web site is a little text box with the label "Search:" to the left of...

Jack Corbett (9/11/2009)

---

Silverfox (9/11/2009)

---

Do you know what really frustates me at times, is when someone posts after you have posted, and says, yes that is correct or says exactly the...

Jeff Moden (9/9/2009)

---

:blush: Heh... that's odd. I was going...

WHOOP!

I'm sitting the same room as Jeff Moden. My IQ has gone up. Who needs a problem sovled?

GilaMonster (9/9/2009)

---

Grant Fritchey (9/9/2009)

---

Oh, hey, Gail, I almost forgot. I remembere, barely, got to it during the Q&A, to put in a reference to the fiber optic laser beam assembler...

It's hard to say for sure, not knowing your queries, your structure or anything about your system.

Probably, those two indexes will work. They both have the same leading edge (the...

shane.barney (9/9/2009)

---

Before I ask my questions, I need to describe the data set. I am working with a copy of a very large data base that grows by 50...

Oh, hey, Gail, I almost forgot. I remembere, barely, got to it during the Q&A, to put in a reference to the fiber optic laser beam assembler during 24 Hours...

Excellent! You should have that big grin on your face. Good job. I'm impressed.

Did you run even when you were sick? Or are you one...

Luke L (9/9/2009)

---

According to Wikipedia... http://en.wikipedia.org/wiki/Swallow

"Species breeding in more tropical areas are often more sedentary, although several tropical species are partial migrants or make shorter migrations."

The pic on the left...

It really depends on the situation in which you are receiving it. Is the server just starting up? Then almost every single query call is going to be a cache...

ClientID is a GUID.

Funny enough, this video was just posted today:

http://www.sqlshare.com/showitem.aspx?id=BD9AAED9-6B7D-4979-ADD5-33436716CCAF

That will show you what the others have described.

PiMané (9/8/2009)

---

Should I have the clustered index even if it's on a "ghost" column, like in my case the column won't be used for anything but the clustered index?

Right now...