The Dixie Flatline (2/4/2010)

---

Gail, I distinctly remember you speaking to one of my co-workers in Seattle and asking him if I did any work at all. Evidently they...

It is possible to configure indexes so that they can be used for Order By and Group By, it's difficult, it cannot always be done. It's something that I put...

Jack Corbett (2/4/2010)

---

I don't want to be responsible for anything. I like just hanging around and trying to answer the ones no one has answered yet. Plus, you...

They can try buying a data retrieval tool to 'undelete' the files, but the chances of recovering it is rather slim.

No backups at all?

Willem's will work, providing you run update usage first. Otherwise the rowcounts can be inaccurate (sysindexes' row count is not 100% accurate)

dbcc updateusage (0) with count_rows

You need a backup that was taken before whatever happened. You cannot take a backup after a crash to undo it.

Do you have a backup from before 12:41? Do you...

Please post new questions in a new thread. Thank you

Ville Lucander (2/4/2010)

---

Select * from table where some_attribute NOT IN (Select distinct some_attribute from table2)

should always be written as

Select * from table where some_attribute NOT IN (Select...

If you want to be precise and formal, yes. I'll use null and interchangeably in logical...

Hi Bob. Where yea been?

Lynn Pettis (2/3/2010)

---

Jack Corbett (2/3/2010)

---

And it probably wasn't me. Now I feel bad....

Is there a question here?

It comes down to the truth table for ANDs and ORs when nulls are involved. (It's in Books Online for anyone interested)

In the case of NOT in,

SELECT n FROM...

Not yet, I'm working on it though.

Can...

Don't worry, same thing happened when I hit 15000. But then I only noticed...