Blog

Index on multiple columns for SQL performance Since clustered index records the table and arranges the data according to the index key, SQL Server allows only one clustered index per table. This results in amazing performance and the worry arises when you need to order the data by more than one column. Since we can't …Continue reading

Indexing: One of the most advantageous methods for increasing the performance of queries is the formation  of efficient indexes.  A well-built index helps the query to avoid the necessity of scanning the entire table for results. If you have created an index, SQL server will automatically measure and stores the equivalent statistical information regarding the …Continue reading

1) Increase SQL Server stored procedure performance with following three tips: Stored procedures play a vital role in enhancing the performance of the database. The following three tips will help us to maximize database performance when stored procedures are used. Use NOCOUNT: If NOCOUNT option is turned off, on each operation: stored procedures returns information …Continue reading

Our New business site is up for us from today : www.macronimous.com . The previous site was around 8 years old, and grown up to over 600 pages of static content. A complete makeover was a challenge and our team was able to achieve it in 3 Months.The main changes are, 1. Layout and Graphic changes …Continue reading

Update (2017): This blog was written in 2009. After 9 years, the life of Dmoz is coming to an end on March 14th, 2017, officially. Dmoz was a challenging Search Directory for SEO professionals of the last millennium. It was powering Google once. It had a powerful search supported by a team of volunteer editors.  2018 Update: …Continue reading

We use Subversion in Macronimous, and I found it would be interesting to share its benefits and our experience with Subversion. It's a bit lengthy entry, kind of Article, But I believe at the end you will find it useful. Web applications are growing tremendously, with more developers involved in finishing the projects. This is …Continue reading

1. SEO is not a one-time process - Like your conventional marketing (Eg. Paper ad), you cannot stop SEO by paying one time, see results stop. Remember you have your online competitors working with another SEO team like what you do.  2. You need to allow your SEO person to optimize content - The content …Continue reading

Most of the performance issues occur because of high stress in the server.  You should perform load testing to know how many concurrent visitors your site can serve perfectly. It is difficult to arrange without the help of a set of actual user. It is the proper way of using advanced automatic load and stress …Continue reading

In general, many neglect SEO for images and some avoid due to ignorance. Using images for SEO is as important as adding Page titles and SEF URLs for SEO. Also, it helps a lot in Google General Image search, as well as product image search. To start, the first step is to make certain that …Continue reading

Many of our customers who look for Ecommerce solutions find Opensource solutions to build cost effective and they like what we recommended, Cubecart!  There are reasons: 1. Easy to customize (skin based)which in turn keeps the cost low. 2. You can bring a great look and feel with skins, you can make the site look …Continue reading