How was the job saved?

If it's dropped / rebuild, then the history is gone.

@dev

Recruiters usually don't troll these forums. You're better off trying to contact them directly.

Also posting your personal info here is just asking for spam.

Have you tried linkedin?

Got the same result. Sql 2K5 Sp3-ish, 32 bit.

Then you need to find the tipping point between fast and slow.

Then provide the actual execution plan for both versions (fast & slow).

Once you have that we can rebuild sample...

So you're un-annoyed now? Or did we just transfer that from the op to us? :hehe:

GilaMonster (11/7/2011)

---

The index is...

... getting there now tho...

sqlfriends (11/7/2011)

---

Ninja's_RGR'us (11/7/2011)

---

So when you rebuild you need AT LEAST another 4.8 GB of free space (unless doing it in tempdb). Since you only have 3.7GB left you have...

SQLRNNR (11/7/2011)

---

Ninja's_RGR'us (11/7/2011)

---

SQLRNNR (11/7/2011)

---

Ninja's_RGR'us (10/31/2011)

---

sqlfriends (10/31/2011)

---

Thanks all.

First, I see the script is so long, I will have to study it a little bit later before I use it .

Second, I...

SQLRNNR (11/7/2011)

---

Ninja's_RGR'us (10/31/2011)

---

sqlfriends (10/31/2011)

---

Thanks all.

First, I see the script is so long, I will have to study it a little bit later before I use it .

Second, I checked in...

The only other argument I have is when you finally find a script that does what you need on the web, 95% of the time it'll fails because of the...

I don't have more patience, but I'm less annoyed :-D.

So when you rebuild you need AT LEAST another 4.8 GB of free space (unless doing it in tempdb). Since you only have 3.7GB left you have this error.

CS = Annoying as hell, even with intellisense. This is from the dev standpoint of course.

You mean the one similar to this? :hehe: