Tweets Seo Tips

I was thinking last couple of days to write on this .. Here are my views on the tweets seo tips

1) Tweet regularly but don’t post in bulk which could annoy followers. An interval of 2-3 hours between tweets throughout the day is good.
2) Use #hashtags regularly & carefully.
3) Use the first word in your tweet because they are used by search engines to rank your tweets too.
4) Tweet within 120 characters so that your followers can easily retweet them using RT @YourHandle in the remaining 20 characters.
5) Include Twitter plugin in your website using which tweeple can spread your word.
6) Try posting same tweets with alternative keywords and hashtags as you are not perfectly sure which ones could bring you traffic.
7) Retweet others’ tweets within the same domain which could randomly bring back people to your tweet and ultimately your blog or website.
8) Create a proper Twitter list so user can follow your list and spread it
9) Look in which timezone majority of your followers are. Post more tweets in their time

I guess i had covered all the tips. If anything more just post a comment


Update two tables from different database

Yesterday i had some tables to move from database1 to database2. I just moved the tables using SQL Export command. After that i had modify some columns in the table in the database1 and now i want to get the old value for a particular column in the table.

So was thinking what to do, then i found i have a primary key column in the table, I used a single update query and updated the data using database name with “..”.

Here is the query

update database1..table1 set column1= (select column1 from database2..table1 where primarykeycolumn=
database1..table1.primarykeycolumn) from database1..table1

This query worked in sql server, Not sure on the other database’s