About
UK Based SQL Server Consultant working for Jarrin Consultancy with extensive experience in the financial, health and retail sectors. I love all areas of SQL Server and specialise in Cloud technologies (Azure and AWS) and really getting my kicks out of Azure Devops, Containers and Kubernetes.
Any spare time I have (when not playing / coaching football and cricket) I’m trying to help out others via social network sites such as the #sqlhelp hashtag on Twitter (follow me @SQLGeordie), running Newcastle’s Data Platform and Cloud and Power BI Newcastle usergroups as well as the Newcastle leg of DataRelay.
Chris, This is Rick Wenger from the SQL Server Forum. You had mentioned about having a look at our DBMS. I really appreciate a second set of eyes on this. Even though we have had timeouts and the like, things believe it or not are better than they were. When I started maintaining this database, they were not rebuilding indexes, none of the foreign keys where indexed and there where Key Lookup out the yeng yang. So, I have improved this somewhat. This system is basically driven off of views that are used to build the grid on the web pages. So basically everything is a view. They have different views for different user access with a particular customer.
My email address is eric….@yahoo.com. You had mentioned that you had some queries that you wanted me to run. Feel free to send them to me and I will be glade to get you this information. I can also be reached at (xx6)xx9-02xx.
Thanks Rick Wenger
Email sent…………note that i censored your contact details on your comment as that goes out to the world!
0 Pingbacks