How can i Limit open connection on my sql server sql
server?
sp_configure 'user options',100 for 100 connections
THis can also be set in SQL Enterprise Manager.. Right click your server and
go to properties...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"?" <anonymous@.discussions.microsoft.com> wrote in message
news:2a49f01c4659d$26b20bd0$a301280a@.phx.gbl...
> How can i Limit open connection on my sql server sql
> server?

How can i Limit open connection on my sql server sql
server?sp_configure 'user options',100 for 100 connections
THis can also be set in SQL Enterprise Manager.. Right click your server and
go to properties...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"'" <anonymous@.discussions.microsoft.com> wrote in message
news:2a49f01c4659d$26b20bd0$a301280a@.phx
.gbl...
> How can i Limit open connection on my sql server sql
> server?

How can i Limit open connection on my sql server sql
server?sp_configure 'user options',100 for 100 connections
THis can also be set in SQL Enterprise Manager.. Right click your server and
go to properties...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"'" <anonymous@.discussions.microsoft.com> wrote in message
news:2a49f01c4659d$26b20bd0$a301280a@.phx.gbl...
> How can i Limit open connection on my sql server sql
> server?

.NET Database/General Performance

Can someone please explain what I'm missing?

Looks like, from my investigation on the net, that 1500/s is pretty much the upper limit of .NET's ability to insert records. Can anyone tell me why? I have tried using UpdateBatchSize properties of 300, 500, 1500, 4500 all of which resulted in a max of 4 seconds difference over 90,000 records.

Why can .NET only insert 1500/s when DTS can do roughly a million in a little over a minute, which is approximately 10 times the performance? Both were doing only simple inserts. Due to my processing needs and integration with other apps, I really need to do the loading from within the app.

I have also written a lot of automation in Visual Basic and C++ before, and when I rewrote it in .NET, the performance was abominable. I am concerned that .NET is not a great language for performance-oriented tasks outside the core application. It does not interface smoothly or quickly with outside technologies as far as I can tell.

Within the application, I don't seem to have a problem, as I was able to write a parser to evaluate 100,000 boolean expressions in less than half a second (simple expressions, mind you). This used a lot of Regex expressions and evaluation code, so it's not that the code is running slow.

Anyone out there seen similar performance with .NET? Anyone from Microsoft that can help explain this?

Programming languages are not the best solution for bulk inserts.

.NET is a lot faster than plain old VB when used properly. Unmanaged C++ still rocks of course.

There are some great articles on MSDN about Data Access (and general performance) with .NET. Maybe you could check these out.

**longest text in SQL**

Hi
I'm working with SQL 2000 and I want to know what data type is suitable
for long texts and what's the limit for its length?
Any help would be thankful.You can use TEXT or NTEXT.
TEXT has a limit of 2GB, but does not support Unicode data. NTEXT has a
limit of 1 GB and can support Unicode data.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
<R> wrote in message news:ops8av5uypmw7tkz@.system109.parskhazar.net...
> Hi
> I'm working with SQL 2000 and I want to know what data type is suitable
> for long texts and what's the limit for its length?
> Any help would be thankful.|||varchar(8000) can hold 8000 bytes and can be used in string functions
text can hold 2GB but can only be a variable by being a parameter on a
stored procedure/function and can only be used in certain string functions
and cannot be assigned.
nvarchar(4000) holds 4000 bytes and is unicode.
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
<R> wrote in message news:ops8av5uypmw7tkz@.system109.parskhazar.net...
> Hi
> I'm working with SQL 2000 and I want to know what data type is suitable
> for long texts and what's the limit for its length?
> Any help would be thankful.|||text datatype takes 2GB of data. If 8k is enough go with the varchar or char
datatypes.
MC
<R> wrote in message news:ops8av5uypmw7tkz@.system109.parskhazar.net...
> Hi
> I'm working with SQL 2000 and I want to know what data type is suitable
> for long texts and what's the limit for its length?
> Any help would be thankful.