Archive for June, 2009

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.

Query Execution Plan Before indexing

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.

Query Execution plan Analysis

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

Create Index On Table

Include columns in index

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.

Query Execution Plan After indexing

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

Please correct me if I am wrong anywhere. 🙂


Read Full Post »

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 : 336×280 Large Rectangle, 300×250 Medium Rectangle and the 160×600 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.


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

Read Full Post »

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.

Read Full Post »

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
database publishing wizard

Step 2
database publishing wizard

Step 3
database publishing wizard

Step 4
database publishing wizard

Step 5
database publishing wizard

Step 6
database publishing wizard

Step 7
database publishing wizard

Step 8
database publishing wizard

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 !!  :))

Read Full Post »