210 reputation
510
bio website saravanandorai.blogspot.com/…
location Chennai, India
age
visits member for 3 years, 4 months
seen Nov 6 at 18:34

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/

Twitter: @sdoraiswamy


Dec
17
comment How to avoid using the IN clause in sql query used in a stored procedure
@JonSeigel: We are using this as part of the Bulk User Management process Jon, so we have to use it.
Dec
17
comment How to avoid using the IN clause in sql query used in a stored procedure
@MartinSmith: The userId are uniqueidentifier datatypes. I have userId as primary key in usertable and so with the case of memberid. shall i use the option(recompile) in the stored procedure.
Dec
17
comment How to avoid using the IN clause in sql query used in a stored procedure
@MartinSmith: I am having index on userid and memberid. The table will be a DataTable [From ADO.Net]. I will pass 25000 rows in the table. Kindly suggest a best solution if any
Dec
8
comment Getting the metadata about a Query and a Stored procedure in SQL Server
also tell me if there is any way to get the parameters in an sql query.
Dec
8
comment Getting the metadata about a Query and a Stored procedure in SQL Server
When i try to execute this code via C# in .NET, for the query BEGIN TRAN t1;SET FMTONLY ON; Select * from Users; SET FMTONLY OFF;COMMIT TRAN t1;, i am not getting the column metadata. I am just getting no values read through the SqlDataReader
Dec
6
comment Getting the metadata about a Query and a Stored procedure in SQL Server
Can I use this in my C# queries also.
Nov
15
comment Doing a bulk insert in SQL Server
I thought that i can use the BEGIN TRAN t1; Insert... ; before i came to know about the bulk insert. is that not a good choice.
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.
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.
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
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
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].