Certain To Perish?:hehe:

Sunspots, seismic activity, who knows. If a page gets written over in some manner, you're probably only going to see it in two calls, the one that wants the page...

I don't know if I'd call poking holes in water the "front lines" but from what I saw of the AF, you guys had it pretty sweet.

And Jeff, don't be...

Sounds like you might have a corrupt database. Can you try running DBCC checkdb() against it?

Jeff Moden (3/13/2008)

---

Heh... I knew I liked you for some reason... I was the Sr. Ping Jockey forward of frame...

Matt Miller (3/13/2008)

---

Grant Fritchey (3/13/2008)

---

I got hired once because I'd been in the Navy... that's as close as I've got to an "outside" talent getting me hired story... Jeez, that...

That's why they call us glowy bubble-heads....

I was working Engine Room Lower Level one day when the Upper Level guy was starting up one of the electrical generators. It's a...

Brandie Tarvin (3/13/2008)

---

Bob, I have only one thing to say to your story... OUCH!

At least your "current" employer was looking out for you, though. Still, it would have been...

Based on the description I still don't understand what the temporary view was doing for the query in question.

I got hired once because I'd been in the Navy... that's as close as I've got to an "outside" talent getting me hired story... Jeez, that sounds pathetic.

What would a "temporary" view do that a query doesn't?

You ought to go and read up on these topics in the Books Online(BOL) (the SQL Server documentation that gets installed with the product). Then, if you have specific questions...

Course not. I wasn't worried about that. But I was being lazy & you caught me on that.

Yeah but when you run two queries each shows a relative cost to the execution as a whole. Usually the speedier, lower cost, process shows as a smaller percentage of...

Can you show the execution plan for this query? Output it as XML and attach it to a post.

You may want to look at SSIS as a mechanism for moving...