Month: May 2009

Do you really need an SEO consultant?

At present, you have a website that has been designed and developed meeting your business needs and you admire the look and feel of your website, easy user interface, and functionality for your customer, and thinking how you and your business will be known to your customers? Then you need to think of popularizing your website to your online customers and getting traffic to your website. Well to reach your customers you need to get help from an …

Database Optimization Techniques to Increase SQL SERVER Performance – Part III – Index on multiple columns

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 use clustered index for multiple columns, a unclustered index is used to gain an increase in performance. We can specify a key value …

Database Optimization Techniques to Increase SQL SERVER Performance – Part II – Increase query performance with indexes and statistics

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 distribution of values in the indexed column. The optimizer which determines the optimal strategy for evaluating a query uses this statistical information. There …

Database Optimization Techniques to Increase SQL SERVER Performance – Part I – Increase SQL Server stored procedure performance

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 concerning the number of rows affected and it increases network overhead. By default, the Option NOCOUNT will be turned off.  If we turn …

Our new site is up! – www.macronimous.com

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 (With same colors as the previous site) – It is three column now. 2. Tableless XHTML/CSS coding 3. W3C compatibility 4. Content Addition …

Is Dmoz dead or editors active?

We all know Dmoz was the largest human-edited directory on the web and the link juice from DMOZ produces good Google ranking. A large group of editors managed Dmoz who was getting your site registered by the Open Directory (http://www.dmoz.org) was vitally important as far as search engine positioning is concerned. In earlier 2005 I used to add sites in Dmoz and it gets listed within few weeks but not from 2006. In mid-2006 their Service was Unavailable, …