I was wrong about the good enough plan "warning".

Gail has some sweet info and bottom line is that good enough plan is better than no warning at all (she posted...

Just BTW, doing that by hand should take you less than 10 seconds per DB. So that's 4 minutes if you include reading this message in your mail, then...

Yes >>>

george sibbald (7/12/2011)

---

if its all your user databases:

select 'alter database '+name+ ' set recovery full' from master.sys.databases where database_id > 4

execute in text mode

copy and paste results to another...

Not me.

I'd try contacting the MVP you refferenced earlier. I think this is your best best at this point. It's unlikely than more than 1-2 people, if anyone...

I'll let Grant or Gail take over from here.

Ya but for it to work on a programmer with mensa QI IQ now that's a feat all on its own!

It's not basic at all actually.

I'm no expert in waits but I'll hang around if I can help more.

What's the normal use of the system? OLTP, OLAP, both?

What's the...

Shouldn't cause the error... I think your error was more about the folder being missing or not having permissions to write there (sql server service account).

http://www.sqlservercentral.com/articles/administration/2960/

http://www.sqlservercentral.com/articles/sql+server+2008/63491/

http://www.sqlservercentral.com/articles/SQL+Server+2008+R2/70092/

CREATE TABLE #test

( id INT NULL)

CREATE CLUSTERED INDEX #CIX ON #test (id)

INSERT INTO #test (id) VALUES (null)

INSERT INTO #test (id) VALUES (1)

INSERT INTO #test (id) VALUES (2)

INSERT INTO #test (id)...

I don't know any Portugal DBAs.

Here's what I used. Keep in mind that it still takes a deep understanding of the product to make most uses of this product.

http://www.sqlsentry.net/plan-explorer/sql-server-query-view.asp

TheSQLGuru (7/12/2011)

---

Actually I much prefer FtF for the first stage of any significant engagement too. But for "hey, this one thing is broken and I need help on it...

Here's the link to article #2. ...

Ignore the Good Enough Plan Found comment, Gail had more info than me on that topic. Bottom line is that this is not an issue.

I've read a really good...

TheSQLGuru (7/12/2011)

---

HAH - I am 0...