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 Security but really get my kicks from System Optimisation and Performance Tuning.
Being a DBA is a thankless task at times but sadly I do enjoy it. Any spare time I have (when not playing rugby, football, cricket, in the gym or spending time with the family) I’m trying to help out others via social network sites such as the #sqlhelp hastag on Twitter (follow me @SQLGeordie), www.sqlservercentral.com (ChrisTaylor) or by running the #SQLNorthEast (@SQLNE) UK SQL User Group (www.sqlserverfaq.com) and sqlrelay held in Newcastle.
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