600 GB large???????????

I just edited my previous answer with more details.

Good luck.

Hell yeah!

You need to consider what queries are running. If they are using the guid as the main filter : Select * from Whatever Where guid = 'dfkjsd'....... and...

I already answered...

You forgot to tell that it's SUMMER down there :P.

They shouldn't, unless manually deleted.

But they could be part of some undelete trash can.

Am I reading right, 617 GB???

Assuming the drop succeeded, that might be some windows error.

Have you tried rebooting the server?

What was the size of those files?

Check if windows didn't grow the paging file.

Also temp files might have gobbed it back up.

There are 12s of explanations, especially on the system...

Yup been there, done that. Don't put the clustered index on the GUID, ever.

All those variables are empty... null is the only thing that can come out of this.

What exactly do you need to do? There's no need for a function here...

Jack Corbett (1/7/2009)

---

Michael Earl (1/7/2009)

---

I moved out of there years ago - that entire section of the country is creepy.

Now I'm in CT - we only burn cars at Dave...

And btw, most servers can handle 50K insert in less than 1 sec. So in a day will not be an issue, ever.

What is the current table definition? Maybe there's a valid natural key in there.

You need to add the where condition in the exists clause.

select q.m_date, q.mday_num

from qvi_app.dbo.mcal q

where not exists

(select * from view_app.dbo.mcal i WHERE q.m_date = i.m_date and q.mday_num =...

One thing I quite obviously found is that even if the query runs in seconds, it can take minutes... hours to render the report.

It's quite easy to spot, if you...