[font="Comic Sans MS"]What do you suggest then? It might be a...

[font="Comic Sans MS"]Thanks! Gail. I would be in a better position to tell you the requirement once I get some knowledge from them, and then I'll post things over here.

Regards,

Faisal

[/font]

sgmunson (8/13/2014)

---

Indeed, 9 million rows is an awful lot of data. Also, even assuming the report still has to exist, your execution plan is suggesting an index creation...

GilaMonster (8/13/2014)

---

What is anyone going to do with 9 million rows being returned for a report? No one, ever, is going to read more than a small portion of that.

Start...

GilaMonster (8/13/2014)

---

You can, and the attach will fail.

You need to find that...

Eirikur Eiriksson (8/13/2014)

---

faisalfarouqi (8/13/2014)

---

[font="Comic Sans MS"]The free space is not pretty much as to accommodate another db as the db is around 5 TB. Secondly, I don't have a file...

GilaMonster (8/13/2014)

---

You need to either find that file (P:\Mnt\DATA4B\CDW_F_MOBILE_INSTRU_FACT_20140705_4_OLD.ndf) or restore a backup of the database.

The file, whatever it is, is a critical part of the database. Probably part...

[font="Comic Sans MS"]The free space is not pretty much as to accommodate another db as the db is around 5 TB. Secondly, I don't have a file backup available

Is there...

[font="Comic Sans MS"]Thanks! buddy....

anthony.green (8/11/2014)

---

Could try something like using BCP to export the varbinary column out to a file, that might work, or a CLR procedure which reads and writes the varbinary out...

LutzM (8/11/2014)

---

In your very first post you mentioned the result is used by people looking at it.

It's rather unusual to present 280k rows to a user...

So I need to ask:...

GilaMonster (8/11/2014)

---

You *need* to run frequent stats updates. There's no way around that, you can either run frequent stats updates or have terrible performance. Index defrags, not such a critical...

[font="Comic Sans MS"]Thanks! bub. However, I am looking for an alternative to get that done...may be extract that out from db to a file (could be an img file or...

[font="Comic Sans MS"]Thanks! but that's not the answer I am expecting...there has to be some other way of doing it. May be import\export or something I am not sure off.

Regards,

Faisal

[/font]

GilaMonster (8/9/2014)

---

Update the stats, run the query again and post the new actual exec plan please. Currently the incorrect row estimations are messing everything up, it's not going to be...