AbleCommerce Gold How To Clean Up Anonymous Users

Even though Able Gold has a manual cleanup option in the Maintenance page, it doesn’t always work well.  The problem arises from how Able must delete each user individually.  Not such a big deal when you have 500 users to clear out.   It’s a very different story when you have 2,000,000 unwanted users.   A SQL query can delete all of the unwanted records in a single command. Below is the updated query to work with Able Gold schema.  Obviously change the dates to something more recent.  If the queries do not remove ...

Apr 14, 2014 READ MORE
SQL Studio Management Expand Databases Slow

So on my development PC, I’ve noticed that it takes 2-3 minutes for the Databases node to expand in my SQL Server Studio Management 11.0.2100.60 I don’t remember exactly when it started.   But it’s been several months I think.  It was just too easy to ignore since I could alt-tab and do something else while it worked through the delay. Today I decided to research it and determined it’s because some databases have auto_close turned on.   This causes the SQL server to have to start up the database before it can render it in the Databases node...

Apr 14, 2014 READ MORE