How to Improve slow running query performance using an Index ?

I recently come across the situation where my query was running very slow. I written a perfect query with good inner join and with proper condition. Have a look at query and its executing plan.



As you can see in the image query takes 1.28 minute to execute successfully. And as you can see in the figure , cause for the problem is Clustered Index Scan on LotDetails Table.

See the image below to get the clear idea about Clustered Index Scan Cost in this query.



What I did was Created Non-clustered index on “SlipID” and added “Active” column into Included Columns.






After doing this when I run my query it took 0 second to execute successfully. And Clustered index scan is now turned into Index seek which is 3% of the total execution cost.



So use index as and when required to boost the performance of your T-SQL Query.

Please correct me if I am wrong anywhere. :)

Six Useful tips To Earn Money With Google Adsense

I recently went through different articles written under AdSense Help Section. All articles are worth reading if you are interested in earning good income with Google AdSense. I found some interesting tips in this section

1. Ad Type : 336x280 Large Rectangle, 300x250 Medium Rectangle and the 160x600 Wide Skyscraper this are the good performer.


2. Text + Image : Always prefer or give a try to Text and image ad combination.


3. Positioning Ads : Ad just above the website content or just below the end of the content tends to perform well. Also, ads placed in between the content are also a good performer. If are you running a blog then the case may be different. In case of blog the add unit on the right hand side and add unit just below each post is very good money making machine.
   Reference : https://www.google.com/adsense/support/bin/answer.py?answer=43869 https://www.google.com/adsense/support/bin/answer.py?answer=17954


4. Wider ad formats tend to be more reader-friendly.


5. Try putting as many ads you can in page. Right now you can place only 3 ads per page.


6. Colour : Change link colour, ad content colour and title colour depending upon your webpage colour scheme. The impact of using this technique is user would have difficult to understand that whether it’s google ad your website link.

Reference : https://www.google.com/adsense/support/bin/answer.py?answer=17957

Click on the link below to find out all the useful tips given by the google for adsense.

https://www.google.com/adsense/support/bin/static.py?page=tips.html

Note : I have just try to summarise whatever is written in Google Adsense help section. All credit for this goes to Google Adsense Team.

Right Keyword Selection for SEO

In this post I am going to tell you how good keyword selection can affect your site in general.

You open a search engine website , typed some search word(s) and press search button and in return search engine will give you number of results that matches your criteria. So here is my point ? How search engine will return those thousands or millions or billions results? Well, the answer is simple by looking at each page and search for the term you entered.

So when you are selecting keyword for search engine optimization you should think from the client perspective.

Let me explain by example , suppose you have written “Software Consultant India” , What will search engine do when you hit search button,

It will return

• all the pages containing the exact phrase “Software Consultant India”


• all the pages containing the words “Software”, “Consultant” and “India” with nearby relation.


• all the pages containing the word “Software”, “Consultant” and “India” without looking closeness in mind


• all the pages that have links that contain this “Software Consultant India” phrase


• all the pages that has the word “Software”


• all the pages that has the word “Consultant”


• all the pages that has the word “India”

So choose the right keyword you will surely get better rank in search engine.

One more thing to remember is that don’t ever include irrelative keywords in your page. What will happen in that case, even if people found your web site it will be useless for them because your site contain different information than they are looking for.

Bottom line is that Use right keywords and relative to your domain or business.

At any point if you feel that I am wrong then don't hasitate to post a comment with correction.

Database Publishing Wizard - SQL server 2005

The topic is self explanatory :).

What would you do if you want to generate script that contains data and schema too. To generate script with schema is pretty simple but what about data. Microsoft Database Publishing Wizard is the tool that work with SQL server 2005 to generate that kind of script. Below are the steps to get started.

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

this is the example of database publishing wizard 1.1. I have not used the versions after 1.1 because this version served all my purpose.

Download Microsoft SQL Server Database Publishing Wizard 1.1

if you are sql server 2008 user then you can not use this :) because good news is that sql server 2008 has this wizard by default.

Please follow http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx link for sql server 2008 database publishing.

Share your thought with me !! :))

First step towards the SEO

I would not go into detail, I want you to take some action now. Do the things below if it is applicable to your web site.

• Remove Flash
  Flash is useless if you want better ranking in search engine. it does not cater any purpose.

• Convert image into text
  If you have image in your page that contain simple plain text then better you should use real text instead of image. More content on your page better your ranking in search engine.

• Enrich content with good keywords
  If you have enough content for your website then make sure your content is enriched with better keyword. Better keyword matters a lot. To choose best keywords you can use Google Keyword Suggestion tool. Use heading tag, bullet list, bold, Italic effect.
  


• If Possible, Navigation Links should have proper keywords in it.