Hi guys, just yesterday we discovered ~exactly~ the same thing while performing a data audit for a client. About 1000 action notepads were making up 20GB of a 30GB Raiser's Edge database.
Geraldo, rather than running that query, you could be using our Raiser's Edge Table Sizes widget :)
Wayne Pozzar
Hi Everyone,
I used the fantastic free Omatic DBA tool to find out that my Action Notepad table is HUGE. Like 100x as large as any other table.
Any ideas on how to remedy this? I assume it has to do with people copy/pasting images into the notepads but I am at a loss as to how to fix it.
Thanks