I agree, Alvin.

Something you should be aware of, trying hide your mistake makes the mistake even bigger. It is best to admit the error and get help fixing it.

You aren't going to be able to fix this yourself if you can't access the backups. As Jeffery said, you will need to get help. With access to...

On a totally different subject, Anyone hear from Bob lately? Haven't seen him on SSC for a while.

What is your current recovery model? If you had to, can you get the most current backup that, you unfortunately say can't at the moment, exists?

You have never taken a full backup of the database, not even when it was first created?

What type of situation are you trying to emulate? A disk failure where you have lost the entire ldf file?

Or, perhaps, if starts into a flame war? Hopefully not. And it stays away from the personal attacks as well.

John Rowan (7/10/2009)

---

Ha! I'll have to second that one. Not just in forums, but this one...

I have to ask, please try the following queries:

SELECT

*

FROM

Tab2 t2

INNER JOIN Tab3 t3

...

Lynn Pettis (7/10/2009)

---

That's because we don't have the data to see what is going on behind the scenes. I'll wait and see what Luke comes back with on this...

That's because we don't have the data to see what is going on behind the scenes. I'll wait and see what Luke comes back with on this one.

It would help to see the DDL for the base tables (including indexes) and the view. Anything we might do without those would just be shots in the dark.

Please read this article[/url] and follow the guidelines within to post the necessary info so we may better help you with your performance issue.

GSquared (7/10/2009)

---

I've never seen it cause a difference in results. Not with 2k, not with 2k5, not with 2k8.

Not going to say it can't happen, just that I've never...