network profile
| bio | website | saravanandorai.blogspot.com |
|---|---|---|
| location | Chennai, India | |
| age | ||
| visits | member for | 1 year, 11 months |
| seen | 2 days ago | |
| stats | profile views | 7 |
Software Engineer.
Working in C# .Net, ASP.Net MVC.
Have working experience in SaaS
Prior experience in PHP, HTML, CSS, JS.
|
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]. |
