I’m glad to see that there are local IT companies in Maryland with SQL Server expertise. Â My colleagues and I were wondering how to get rid of duplicate rows in a SQL Server table. Â Do you know about this?
Tom in Maryland
I would like to add something like “last updated the xx/xx/200x” on my page.
Can you tell me what the best way to do that is? Are there any functions that will retrieve the last updated date?
Kim from Rockville
The following guide helps you to troubleshoot your SQL Server if its running very slow:
First check the processor and memory usage to see that processor is not above 80% utilization and memory not above 40-45% utilization then check the disk utilization using Performance Monitor, Secondly, use SQL Profiler to check for the users and current SQL activities and jobs running which might be a problem. Third would be to run UPDATE_STATISTICS command to update the indexes.
Although CCD does most of its work using Microsoft products, many people come to us asking about LAMP. The standard reasons for selecting LAMP (Linux, Apache, MySQL, PHP) instead of combination of other software programs, servers and operating systems include:
All of those are open source resource. Security of linux can be much greater than that for windows. Apache can be a better server that IIS both in functionality and security. Mysql is the most popular open source database in the world. PHP is faster than asp or other scripting language.
Our organization is looking for some help with MySQL and PHP. We have a database of clients and potential clients- We would like to publish some of the information in this database on the web so that our team members across the country can easily access it. Is this the sort of computer consulting that you do? I guess you would call it database management.
JL in the District of Columbia
I am in charge of a medium-sized non-profit organization in Washington DC. I am interested in augmenting one of our customized databases and then putting its contents up on the internet for our members and the public to access. My question is: Should I be looking for a web developer, or a database developer for this project? I see from your web-site that you have significant experience in both web development and database management. Thanks in advance,