Viewing 15 posts - 3,901 through 3,915 (of 18,926 total)
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...
August 2, 2011 at 2:36 pm
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.
August 2, 2011 at 2:31 pm
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...
August 2, 2011 at 2:28 pm
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...
August 2, 2011 at 2:24 pm
SSIS package might be the way.
Never done this tho, no idea how easy / hard it can be.
August 2, 2011 at 2:20 pm
bindview (8/2/2011)
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...
August 2, 2011 at 2:19 pm
Help us help you, how can I possibly answer that without seeing the tables' definition?
August 2, 2011 at 2:17 pm
GilaMonster (6/6/2010)
Two-year-old-thread alert.
Actually 3 years now.
August 2, 2011 at 2:14 pm
sunny.tjk (8/2/2011)
August 2, 2011 at 2:13 pm
Lowell (8/2/2011)
lemme see where i put Remi's password again....
No need to look, here it is (yes it's actually a real password)
pX725JwUGbe4e7SO2Q
August 2, 2011 at 2:10 pm
Ok, stepping aside, not my strongest expertise.
August 2, 2011 at 2:08 pm
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...
August 2, 2011 at 2:08 pm
Is the DAS purchased or ou can still have other options like a SAN?
If not, what's the budget?
August 2, 2011 at 2:05 pm
GSquared (8/2/2011)
Ninja, I think you ended up quoting the wrong post.
Yup. But you're smart enough so that I don't have to go back and edit it.
That's what I love...
August 2, 2011 at 2:04 pm
Viewing 15 posts - 3,901 through 3,915 (of 18,926 total)