Brandie Tarvin (11/17/2011)

---

Ninja's_RGR'us (11/17/2011)

---

Dev (11/17/2011)

---

I did my best to explain why it should not be used and was met with the same response. I got on the phone...

The only way we can help...

Dev (11/17/2011)

---

I did my best to explain why it should not be used and was met with the same response. I got on the phone about 10 minutes...

It can have effects. That's why it's better to do it in smaller chunks...

SQL_Nw (11/16/2011)

---

Hi Ninja , I could not find data driven subscription tab in my report...

... meaning Gail's still waiting on this =>

GilaMonster (11/16/2011)

---

Wiesinger (11/16/2011)

---

to find the problem I created a simple select with and without the use of an index. Last week we had...

GSquared (11/16/2011)

---

Roy Ernest (11/16/2011)

---

Ninja's_RGR'us (11/16/2011)

---

L' Eomot Inversé (11/16/2011)

---

But it was Remi who said it, and in the thread, and the combination of those two factors seems to me to require...

mak101 (11/16/2011)

---

I tried JOIN but gives me same error, can't join with table variable. That is...

Either go fully dynamic as is suggested in Gail's article or divide and conquer.

Apply the base filters with max effect first.

Save that as temp table, then finish the joins.

The compute...

I just had to take a peep.

restore_date gives you the start time of the restore. Without end time nor lenght it's not really useful. You could always backtrace...

Check the default trace. If it didn't roll over that'll give you the start time for sure.

Then in sql logs you'll have the time it comes online.

(Sorry don't know...

Why, what would you guys do in his shoes?

Dev (11/16/2011)

---

I had one of those. I sat down with the architect and explained to him what NoLock actually did...

Dev (11/16/2011)

---

In any cases I'd make him sign something that says I know this can return the wrong data and this is my decision. Takes you off the...

Roy Ernest (11/16/2011)

---

Ninja's_RGR'us (11/16/2011)

---

L' Eomot Inversé (11/16/2011)

---

But it was Remi who said it, and in the thread, and the combination of those two factors seems to me to require the...

L' Eomot Inversé (11/16/2011)

---

But it was Remi who said it, and in the thread, and the combination of those two factors seems to me to require the most perverse available...