I don't remember.

[/ too easy to ignore]

So you want us to guess at the plan and where it goes wrong not seeing missing index, wrong estimations, actual operator costs?

Sorry dude you're better than that and it...

It's the 1 hour delay that is causing "me" issues.

It wouldn't be the case with 12 or 24 hours between the question and the ping.

Sql Sentry is awesome, but you still need a .sqlplan to work with it.

Missing indexes are contained in the actual plan.

If it "only" takes 55 minutes to run just let...

Not sure how usefull this is, but it gives you a good look into a server.

http://www.red-gate.com/products/dba/sql-monitor/

Even the 14 day trial gives you enough time to tweak a lot of stuff...

SSIS package might be the way.

Never done this tho, no idea how easy / hard it can be.

bindview (8/2/2011)

---

I have a similar issue..

Login Failed for user 'NT AUTHORITY\SYSTEM'. [client:IP]

error:18456 severity:14 state:16

Its default database is master.

Any idea why i am receiving this error even if the default database...

Help us help you, how can I possibly answer that without seeing the tables' definition?

Actually 3 years now.

sunny.tjk (8/2/2011)

---

Hey Ninja, dont get mad or offended for silly things. I just replied to my post because I was hoping it gets noticed by "gurus" like you. "We don't...

No need to look, here it is (yes it's actually a real password)

pX725JwUGbe4e7SO2Q

Ok, stepping aside, not my strongest expertise.

That's your problem right there.

Don't SHRINK. It's a logged operation and there's a whole hell of a lot of stuff to log.

If you're doing that in a...

Is the DAS purchased or ou can still have other options like a SAN?

If not, what's the budget?

Yup. But you're smart enough so that I don't have to go back and edit it.

That's what I love...