Well somewhen on october 1st there was ±3000 posts to go.

So that's maybe 400 posts / day on business days.

With those amazingly precise stats :hehe:, we should get there before...

Have you checked if they are system tables?

It's more likely that it exists but YOUR login does not have access to it so you can't query it or see it in the tables lists.

I've never ever encountered...

No way... we're only getting a few 100s posts per day.

jameyschaetzel (10/4/2010)

---

Derrick,

Thanks for the quick response; so something like this:

UPDATE #temp_client_spend SET actual = (SELECT sum(billdol) FROM tc

inner join mat on mat = mmat

WHERE client = @client and woper...

I'm on 2008 standard sp 1and there's nothing left.

Thanks for the script.

Hmm interesting info here.

Got any scripts that finds those indexes or is it just based on filtering on index names?

getoffmyfoot (10/1/2010)

---

Ow... my eyes...

What I am seeing though is alot of sub-selects in where clauses of sub-selects in where clauses of sub-selects in where clauses in....

Yes I'd like to...

And here's another one.

DTA crashes even with a simplist query but with a DB with 7000 objects.

https://connect.microsoft.com/SQLServer/feedback/details/608926/dta-unsuable-with-7000-objects-in-db

Done

https://connect.microsoft.com/SQLServer/feedback/details/608902/missing-index-es-in-msdb-dbo-dta

Hey that joke still works for GWB's lineage! :hehe:

Steve Jones - Editor (10/1/2010)

---

I think it's an int, might be a big int, but we should be fine for years. Surprisingly, a million is a big number when it...

Another exemple. I have...

Wow, so much content and yet that's...

No dice, I've already done all those things.