• Skip to content
  • Skip to primary sidebar
  • Skip to footer

All My Systems

Sorting your business systems. Properly

01422 824831
  • What We Do
    • Sales systems
    • Customer service systems
    • Marketing systems
    • Social monitoring
    • Field service systems
    • Project management systems
    • Support
    • Training
    • What is CRM?
      • New to CRM?
      • Already using CRM?
      • Using Dynamics 365?
  • Industries
    • Managed Print (MFD) System
  • Blog
  • Questions?
  • Case Studies
  • About Us
    • Contact us
    • Company updates
    • Press coverage
    • Join our team
    • Privacy Policy
  • AMS TV

Clearview Group

The Company

Clearview Clearview magazine is published by the Clearview Group Ltd, an expanding Yorkshire-based, independent publisher of specialist trade magazines across the UK.

They publish Clearview and Pro Installer monthly on a national basis focusing on the broad glass and glazing industry. Also part of the group are the publications The Locksmith, the only independent trade journal and online news publication dedicated to the locksmith industry, The Farmers Mart, the North’s number one farming guide and the group’s newest edition Locksmiths Local, an online directory for the public to find the closest locksmith in their local area.

The Opportunity

Over the last 7 years, the group have developed an in-house subscriber and publisher management system which runs the entire group operations, from lead in to magazine out.

The system data is stored in a Microsoft SQL Server database and users have recently been experiencing the following problems:

  • Application screens keep hanging during normal usage, slowing down order processing and quoting
  • A fundamental process of prospect emails received, to prospect records generated, not working

With over 10 years’ experience in managing SQL Server based databases and improving customer databases, All My Systems were asked to review the SQL Server architecture, system and queries to identify where improvements could be made.

The Solution

We reviewed the architecture of the system and SQL Server with onsite subject matter experts, and implemented the following improvements:

  • Reviewed long running queries to identify where bottlenecks were in the system and optimise these queries to provide up to 44 hours saved query time per year
  • Troubleshooted and identified the cause of the failing process between the front end application and back end SQL database to modify the code and get the prospect records generation process working again
  • Relocated the physical data and log disk layouts to improve scalability and reliability
  • Increased the growth rate of the log file which was previously a performance bottleneck, and slowed the system down each time additional data was added to the system

Hear from the client

All my systems were recommended by one of our directors. At first I was very reluctant to accept any help as this project had become my “baby” over the last 7 years, however after meeting Mark, I could tell my project was in safe hands. The advice and recommendations I received has made significant and noticeable improvements both to me and the users. Mark spent a lot of time listening to me and my thoughts and used these to make the best changes possible, all backed up with thorough reports and communications. All my expectations were exceeded and I would not hesitate to ask for help in the future.

Ryan Exley, Financial Director

All My Systems are looking forward to continuing to work with Clearview Group Ltd to optimise their systems even further.

I’d like this for my business too

Complete this form and we'll get back to you right away

First Name


Last Name


Company Name


Telephone Number


Email Address


Primary Sidebar

Recent posts

  • Our Systems Broke – AMS TV 56
  • Better Mobile Working – AMS TV 55
  • You’ve Got CRM All Wrong – AMS TV 54
  • See Through Your Customers’ Eyes – AMS TV 53

Topics

Business case (17) , CRM culture (13) , Data management (13) , User adoption (12) , Productivity (12) , Integrations (11) , Reporting (9) , Outlook (8) , Business growth (8) , CRM introduction (8) , Customer service (6) , Support (5) , Mobile working (5) , GDPR (5) , Marketing (5) , Training (5) , Project management (4) , Tips (4) , Sales (3) , Finance (2) , Knowledge management (2)
Microsoft Dynamics CRM
We're a Microsoft specialist in Dynamics CRM
ClickDimensions Email Marketing and Marketing Automation for Microsoft Dynamics CRM

ClickDimensions partner
Email Marketing & Marketing Automation for Microsoft Dynamics CRM

BCS Professional Member - The Chartered Institute for IT

BCS Professional Member
The Chartered Institute for IT

Footer

Contact

All My Systems Ltd
Unit 1
The Craggs Country Business Park
Cragg Vale
West Yorkshire
HX7 5TT

P: 01422 824831
E: hello@allmysystems.co.uk

Company No: 08977758



We are proud to support Forget Me Not Children’s Hospice
Forget me not children's hospice

Memberships

Connect Yorkshire
Federation of Small Businesses
Huddersfield Town AFC partner

Recent posts

Does Microsoft Dynamics Integrate With Power BI?

Will We Have To Pay For Additional Reports?

We Already Use Office 365, Can We Start Using Dynamics?

More Posts

Tweets

  • That link is broken - correct link is https://t.co/AQ5EnZcLtK https://t.co/DlEwMYFrrb December 18, 2018 3:16 pm
  • See business through your customers’ eyes at our customer journey mapping workshop. We've got some free places left… https://t.co/AAe8vzLdQH December 18, 2018 2:22 pm
  • Want Help Making The Case For A #CRM ? https://t.co/SHjsKZjhbI December 7, 2018 8:39 am
  • More tweets

© 2019

  • Contact
  • About
  • Blog
  • Case Studies
portfolio