Finally I can see some data

It is real fun that when you see the tool shows you some data after putting some efforts into the site. That is my way to test out the sites visibility.

To improve the visibility of your website, there are several points you have to verify:

First of all, the on page factors. These are basic stuffs that you have to look at. If you optimize them, you have a good foundation. However, that doesn't means you will rank high by doing these basic things. Because most of the websites have done that already. If you don't do, you won't be ranked even with tons of other efforts.

Secondly, you have to pick good keywords, that can drive you traffic and profits. That sounds easy, but not that simply as you thought. High traffic keywords always have higher competitions. What are you going to do?

Last but not the least, back links from other reputation sites. The way google beat yahoo is that google use back links to evaluate a site. So you know how important they are.

In conclusion, we need to check quite some elements to ensure our sites' visibility on the internet.

partitioning in SQL Server 2005

I am working on an assignment of migrating a database from SQL 2000 to 2005. That is not a big deal. But at the mean time, there is a huge table contains orders in the database which I want to partition it. In oracle, we can use redefine package to partition an existing table, this won't be an issue. However, this is SQL Server...so I have to determine what is the best practice...
1)migrate the whole db, create a new partitioned order_new table, move the data to the order_new, rename order to order_old, rename order_new to order.
2)migrate the whole db, use scripts(if there is any) to partition the existing order table.
3)migrate the whole db except the order table, create a partition one on the new server, import the data.(the migration might encounter constraint issues, not a good approach)
4)any other ideas?

my new Site for quality link building

I think the team should focus on building quality links.

About being a good DBA

A set of useful DBA Script is a must have tool.