Database

The key to your argument should be about cost; each cost can then have a technical answer to the question - for example, annual maintenance cost is $500k as we need to employ a team of DBA's to manage 1000's of databases Give your suggested solution with a cost, give his solution with it's associated costs. You can always ham it up a bit to ensure that your solution looks better. This will get his interest far more than technical discussions on the merits or otherwise of solutions.

you can also download the given sample code to learn how to store and retrieve image from SQL server. Click on the given link to Download Click me[^]

jeyaranjani wrote: random question retrival from database :confused: Don't try to post like this always post with fact question Make a connection and get all data in your dataset and then use Random keyword and get all data from dataset in randomly way.

Using stored procedures, more of a good thing than using dynamic SQL? The article makes a good argument about changes legacy systems. The need to change the stored procedures will break code, or adding more stored procedures adds extra (duplicate) overhead. If just adding a new column to a table requires adding a new input parameter, we will need to add a new stored procedure to handle it. Of course, the old stored procedure can call the new stored procedure with a dummy argument for the new input value. On the other hand, using dynamic SQL may require revision to add the new parameter (where it is needed). The down side is that legacy code that uses the database will need to have its SQL updated. Not only will the new application making use of the "improved" database have the changes, but all of the older applications will need to change, if the new database is used with them. And, there is the possibility of SQL injection attacks, depending on how you store your SQL in your application. Updating Stored Procedures is akin to the old days of COM programming. There was a rule, at one time, that said we should not change a published interface, but make a new interface. This also was applied to the methods as well. And, a good programmer will do the least amount of work to get the job done efficiently. You must decide which method is best for you.

Sounds to me like the program should be re-written, not the database. Of course this may be a simplistic accessment because I am not familiar with your problem domain, but, why would you have the program always load the entire database rather than just the record currently being worked on? Most progams that work with a database have some sort of search function to allow a user to find the record they need (returning only minimal identifying data), then a detail form/page that is used to work on that record. This way you are never loading much more data than you need and since the record is getting loaded just before working on it and saved immediately after, it should always be relatively current. The only concurrancy problem you have then is if two users are working on the same record at once. Hope this helps. Kevin Rucker, Application Programmer QSS Group, Inc. United States Coast Guard OSC Kevin.D.Rucker@uscg.mil "Programming is an art form that fights back." -- Chad Hower

You could have search Google, having a lots of result on it. See THIS[^]. Regards, Hiren. Microsoft Dynamics CRM My Recent Article: - Way to know which control have raised PostBack[^]

Thanks very much Hiren, for the help. I will try that. Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

Uh, I think you meant to post that as a reply to the OP's message and not as a reply to mine. [Forum Guidelines]

Well said. With Regards, Kasson

Seems to me there is a fundamental flaw in the process, the web services should be your bottleneck but for a database to only be updating 30k records an hour seems ludicrous. If the cursor/loop is the problem then look a little further afield. Can you construct an xml dataset on the UI end and pass in a bulk set of updates. How about doing a bunch of bulk inserts into another table and then using a proc to do the updates to your transaction table. Target tables could be created for each instance and truncated after the update. Or cycle through 2 target tables per instance. Never underestimate the power of human stupidity RAH

jrahma wrote: why this statement returns error on mysql?! It'd help if you'd post an error-message :) I are Troll :suss:

Use ServerProperty() Function. See MSDN[^] For more details. Regards, Hiren. Microsoft Dynamics CRM My Recent Article: - Way to know which control have raised PostBack[^]

Hum Dum wrote: SELECT @address = CONVERT(VARCHAR(150),[TEXT]) FROM OPENXML(@idoc,'/Name_Address/address', 0) where [text] is not null AFAIK the result is having two rows returning and At a time of converting SQL might picking up the second row and converting it accordingly, As It returns two rows having one column. But I can Provide you another solution for that. To first Retrieve the result and using COALESCE you can JOIN them together to produce expected result. Here's my work for you only. SELECT @address = COALESCE(@address+',' ,'') + [address] FROM ( SELECT * FROM OPENXML (@idoc, 'Name_Address/address',3) WITH ([address] varchar(1000) '.') ) P SELECT @address It's working all right. Regards, Hiren. Microsoft Dynamics CRM My Recent Article: - Way to know which control have raised PostBack[^]

That depends on the density of the disk.

DIR

Does MySQL _hav_e a server?