Posted from WordPress for Windows Phone
Posted from WordPress for Windows Phone
12
Feb 2013
Today was a great day. I had moved my blog to godaddy hosting and installed new theme. Planning to start my blog journey again.this time I plan to write on technical and also what is happening around me. Need to write at least two post in a week.
Let’s hope for the best
Have a great week
Category: General
Leave a Comment
11
Feb 2013
Reposting it again 
Today i had a problem. when i checked my database LDF file (log) file it’s some where around 25GB. I was trying to shrink the file it’s not possible. Could not able to shrink it from management studio. Found an workaround for that, Here the command for it.
First make the database to SIMPLE Recovery mode and do it.
– Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE [databasename]
SET RECOVERY SIMPLE;
GO
– Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE ([log file name], 1);
GO
– Reset the database
ALTER DATABASE [databasename]
SET RECOVERY FULL;
GO
Let me know if any questions
Elam
Category: Technical
Leave a Comment
04
Feb 2013
Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!
Category: Uncategorized
Leave a Comment
22
Jul 2012
Yesterday when i was looking at my website data i found most of the my visitor are single page visitor. Who came down to my 2 post one is for SQL server and another to Jquery page. Both the posts ranked well in the google. Now my problem is how to convert this visitor to see other posts ? .
Here is what i am planning to convert the visitor
1) Given the link to other corresponding pages in that post
2) Written couple of continues post for that topics
These will increase the visitor. will update the post again in another one month
Regards,
Elam
28
Mar 2012
Today i had a problem. when i checked my database LDF file (log) file it’s some where around 25GB. I was trying to shrink the file it’s not possible. Could not able to shrink it from management studio. Found an workaround for that, Here the command for it.
First make the database to SIMPLE Recovery mode and do it.
– Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE [databasename]
SET RECOVERY SIMPLE;
GO
– Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE ([log file name], 1);
GO
– Reset the database
ALTER DATABASE [databasename]
SET RECOVERY FULL;
GO
Let me know if any questions
Elam
25
Mar 2012
Hi all,
It’s been very long time since i updated my blog. i am really sorry for that. Well coming to the topic. I was working for one of our entrprise customer. We have web analytics data close to 90GB. we are building another application to displaying the data, so i need to migrate the data to new database.
Intially when we started our migration it takes almost 6 days for one month data. I was wondering what to da. Then i followed the below mention steps and it come down to 3 Hours for one month.
Steps
1 check for each query execution time and also the subtree cost. to get subtree cost include execution steps from the top bar in management studio. When sub tree cost is more sql server uses full 100% cpu time and memory.
2 created the index for each table. while creating index make sure you create index for all where condition combination.
3 use temp table instead of union all query. Because i combine almost 60 table in single query. So instead of union all i used temp table to get the data
4 remove unnessary column in the select statement
Once you follow this points. It will increase the website and sql performance
If any questions just mail me or add a comment
Elam
01
Feb 2012
Today I had an issue For one of our customer. They had implemented the Google analytics tracking code in their website and they have so many sub domain which they want to track in main domain GA profile Id. They had implemented the Ga code properly and also used _gaq.push(['_setDomainName', '']);, but the problem is the sub domain is still capture as new visit.
when I check the problem it simple they forget to change the subdomains option in the GA profile settings page. it need to be like this
After I changed this also it was not working. because they had added “.”(dot) before the domain. For example if you want to capture the sub domain for elamparuthi.com. we need to set it like this
_gaq.push(['_setDomainName', 'elamparuthi.com']);
Not
_gaq.push(['_setDomainName', '.elamparuthi.com']);
I used GA debugger chrome extension to debug this. it’s really nice tool.You can download it from here
https://chrome.google.com/webstore/detail/jnkmfdileelhofjcijamephohjechhna
Elam
Category: GA, Technical, Web analytics
Leave a Comment
20
Dec 2011
Today my friend karthi told me how my blog was useful to him and his team on the project. I was really happy. I stopped updating my blog regularly because of poor response of visitor, today when he said that I was really happy and plan to update my blog on regular basis because I sometime it will help others.
Thanks karthi for positive response and I am starting to write again
Elam
Category: Personal
Leave a Comment
30
Sep 2011
Today Google had released the google analytics premium account with the price band of $150,000 per year, i was really shocked on the price band, no idea how many enterprise customer will go for it. In general google analytics premium account we have some nice stuff like
- Run sql query aganist your data
- Client will owns the data
- 24/7 support
- 50 custom variables
Here is the GA account comparison
Because of the data Data ownership may be most of the enterprise company can look to move to GA permium account
Competition is healthy for any industry to grow and progress, but Google appears to be doing this all by itself in the field of web analytics.
will write a another post tomorrow on drawback in free GA account
Regards,
Elam
Category: Personal, Web analytics
Leave a Comment