Easy, kick off the job that loads the data during the week-end at 4 PM friday rather than "off" hours. :hehe:

Jeff Moden (6/12/2010)

---

David Portas (6/12/2010)

---

Maybe you are getting confused because you are asking the wrong questions. First determine what keys make sense from a business perspective. If you are thinking...

100% correct with the exception that you need select *...

UMG Developer (6/11/2010)

---

lmu92 (6/11/2010)

---

I second Ninja's_RGR'us recommendation regarding the script screenshot.

For two reasons:

#1) it requires at least a little more effort to run it before answering (for those who...

webrunner (6/11/2010)

---

cathy.baker (6/11/2010)

---

No matter if it's a bad question or a trick question. The answer is one. The question was "How many records are returned from the last...

:w00t:

That avatar photo is a bit misleading... Gail is well, more of the female type 😉

Just my 0.02$, I don't care about the points but I fail to see the learning opportunity (for me) here. Like hugo said, you'll get an error as soon...

SELECT MAX(CASE WHEN Flag_a = 'y' then DateA ELSE NULL END) AS Datea

, MAX(CASE WHEN Flag_b = 'y' then Dateb ELSE NULL END) AS Dateb

, MAX(CASE WHEN Flag_c = 'y'...

Remake the plan would be an obvious one. Assuming you are able to edit the plan, then maybe add a db then take it out again should regenerate the...

james.massey (6/8/2010)

---

Ninja's_RGR'us (6/8/2010)

---

How much rows (in % of the total rows in the table) are returned by those 1-2 cases?

Are those rows returning more data than the other correct cases?

How...

Well just to be sure.

What I understand is that 99.9% of the queries, the plan is an index seek. However with a couple cases you get a...

How much rows (in % of the total rows in the table) are returned by those 1-2 cases?

Are those rows returning more data than the other correct cases?

How are the...

Patricia Johnson (6/8/2010)

---

So Does anyone have any experience with SQL 2008 to know the differences between SQL 2008 and SQL 2008 R2?

Thank you for your time and willingness to...

What's bad about that? What's your problem with the situation?

Assuming you are running short of space, you can always buy a cheap 1+ TB drive and keep pilling up...

Still can't work. Exec basically open a new connection with new spid based on the current context. Once that exec is over the use is.. well useless.

The whole...