200 reputation
39
bio website saravanandorai.blogspot.com/…
location Chennai, India
age
visits member for 2 years, 10 months
seen Apr 11 at 12:21

Software Engineer.

Working in C# .Net, ASP.Net MVC, Kendo UI, jQuery etc...

Have working experience in SaaS

Prior experience in PHP, HTML, CSS, JS.

Linkedin Profile: http://in.linkedin.com/in/sarandorai/


Nov
15
comment Doing a bulk insert in SQL Server
I will check it and comeback to you. In the mean time, can you tell me if using a C# transaction as the outer transaction and a SQL transaction command like BEGIN TRAN t1;INSERT.....; INSERT... ; COMMIT TRAN T1; will work as i had this idea, just for knowing if this is a possibility.
Nov
14
comment Doing a bulk insert in SQL Server
SQL Server 2008 and above is what we use.
Nov
14
accepted query regarding combining an update and an insert query into a single query in mysql
Nov
14
asked Doing a bulk insert in SQL Server
Sep
26
accepted SQL Server Data types and operators clarification needed
Sep
26
asked SQL Server Data types and operators clarification needed
Sep
13
awarded  Scholar
Sep
13
accepted How to get the foreign and primary key details for a table in SQL Server 2008
Sep
13
comment How to get the foreign and primary key details for a table in SQL Server 2008
@Aaron: It was late night here,so only i was not able to reply to you. I needed both the tables and the columns but have to run separate queries now. I will use your queries in your reply. Thank you.
Sep
13
comment How to get the foreign and primary key details for a table in SQL Server 2008
Thanks for your help. These queries really help me. I did not have the in depth knowledge on the database objects, hence had to use a suggested query, however i felt that it was a bit unclear for me. Hence I posted here. I will learn about the database objects, hope msdn has some good documentation, else you can suggest me one. Your script is clear and easy to understand than the one i have.. Thank you.
Sep
12
comment How to get the foreign and primary key details for a table in SQL Server 2008
SQL Server 2008 Express Edition.
Sep
12
asked How to get the foreign and primary key details for a table in SQL Server 2008
Jul
1
comment query regarding combining an update and an insert query into a single query in mysql
@rolandomysqldba: Thanks for your detailed explanation. Here is my understanding, instead of using the statements as such [without any transaction involved], i will use these statements prefixed with a BEGIN and suffixed with a COMMIT from my application code where i set up the query so that in case of any problem, the DB consistency is maintained. Hope i got the point.. please check this one so that i can go ahead. I also have a problem that mysql does not support multiple connections simultaneously , is there a workaround for this. Shall i post it as a new question?
Jun
30
awarded  Student
Jun
30
comment query regarding combining an update and an insert query into a single query in mysql
@rolandomysqldba: this works fine as a single query when i send to a db server from the application code, where i treat this set as a single query. why do you say so?. can you disprove this with strong reasons..
Jun
30
awarded  Supporter
Jun
30
comment Benefits of running the OPTIMIZE TABLE Query in MySQL DB Server
Thanks for your reply. From your point of view, i understand that i better use some service like a cron job to schedule optimize table for one of my frequently updated table so that i can achieve better performance. Further to this i am using InnoDB for this table. Is this a better choice. Also, I find HASH joins in SQL Server which was suggested to kinda improve query performance, can you please explain this for me and how to get a similar one to this in MySQL. Also please give me a SQL Query optimizer for MySQL [Windows7 version].
Jun
29
answered query regarding combining an update and an insert query into a single query in mysql
Jun
29
asked query regarding combining an update and an insert query into a single query in mysql
Jun
29
asked Benefits of running the OPTIMIZE TABLE Query in MySQL DB Server