Other applications using MSDE

What other applications outside Microsoft products, use MSDE?
Hi,
You're asking a question here that isn't possible to answer. There are a
huge number of software vendors that now use the MSDE as one of their forms
of deployment. A large percentage of SQL Server based applications could be
deployed against the MSDE at the lower end of the market. It's a similar
question to asking "What other applications outside Microsoft products, use
SQL Server?".
Sorry there isn't a simple answer.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Moj_Sharp Labs" <anonymous@.discussions.microsoft.com> wrote in message
news:D1298C09-2F40-4CBA-86F7-96BA7DC09CC5@.microsoft.com...
> What other applications outside Microsoft products, use MSDE?
|||sourcegear's version control system, vault, integrates with msde for
smaller based development shops which do not want to purchase a full sql
server license.
http://www.sourcegear.com/vault/
jeff clausius
sourcegear
"=?Utf-8?B?TW9qX1NoYXJwIExhYnM=?=" <anonymous@.discussions.microsoft.com>
wrote in news:D1298C09-2F40-4CBA-86F7-96BA7DC09CC5@.microsoft.com:

> What other applications outside Microsoft products, use MSDE?

OSQL Performance Problem

System info:
Win 2003 Server, SQL Server 2000, test server - no outside access from other users (no other applications running)

Table info:
DocId(int), a(nvarchar(10)), b(nvarchar(20)), c(nvarchar(10)), d(nvarchar(20)), e(nvarchar(10))
DocId has a number, all other columns are null. No index

I am using a stored procedure that updates the values based on the DocId. I have an program that creates a sql script file that should be executed. Approx. 440000 lines.

Example:
Using TableName
Go
SET NOCOUNT ON
GO
exec sp_SPNAME @.docId=1, @.a = 'blah', @.b = 'blah', @.c = 'blah', @.d = 'blah', @.e = 'blah'
GO
exec sp_SPNAME @.docId=2, @.a = 'blah', @.b = 'blah', @.c = 'blah', @.d = 'blah', @.e = 'blah'
GO
repeats 440K.

Question: When I execute this script per osql.exe, the update takes more the 24 hours... Any suggestions?

Thanks in advance.System info:
Win 2003 Server, SQL Server 2000, test server - no outside access from other users (no other applications running)

Table info:
DocId(int), a(nvarchar(10)), b(nvarchar(20)), c(nvarchar(10)), d(nvarchar(20)), e(nvarchar(10))
DocId has a number, all other columns are null. No index

INDEX !!!

Put a clustered index on DocID.

CREATE CLUSTERED INDEX IXc_TableName_DocID ON TableName (DocID)
GO

Regards,

hmscott|||another route is to bulkcopy/insert all the new data into a table then do a single update against the base table. Index on docid would be desired when you start dml.|||Hi hmscott,

thanks for the reply and the sql. I added the index and, while it is much faster, it still takes more than 8 hours. Maybe this is normal for executing 440,000 statements?

Thanks,
Lens|||Hi oj,

thanks to you as well for the reply. I will change my program to make a csv file and see if a bulk update increases the speed.

Thanks,
Lens|||Hi,

just a quick status update. I changed my program to create a csv-file. Approx. 440,000 lines imported into temp table; less than 2 minutes. Update into final table, less than two minutes...zoinks.

Thanks again.