network profile
| bio | website | saravanandorai.blogspot.com |
|---|---|---|
| location | Chennai, India | |
| age | ||
| visits | member for | 1 year, 11 months |
| seen | May 21 at 7:03 | |
| 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.
|
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 |
