How reliable is Microsoft's type4-JDBC driver for MsSQL Server?

Hai Friends,

I am using MsSQLServer in the backend and java in the front-end.

How reliable Microsoft's type4-JDBC driver for MsSQL Server?

I am very afraid as its only a beta version and version 1.0 and my project is a commercial one.

Is there any other better type4-JDBC driver for MsSQLServer available -which i can get for no cost-free of cost. Please guide me.

Thank You

Okay!

I am not going to use Microsoft's type4-JDBC driver for MsSQL Server.

I am going to use jTDC of sourceforge.com

|||

The new SQL Server JDBC driver shipped last month and is quite reliable -- it passes cert suites from all the major vendors and is already being widely used.

Check it out here -- http://www.microsoft.com/downloads/details.aspx?familyid=e22bc83b-32ff-4474-a44a-22b6ae2c4e17&displaylang=en

-shelby

How many result-rows does mssql return should be used asynchronous method to use mssql cur

How many result-rows does mssql return should be used asynchronous method to use mssql cursor, can get the best performance in any time in any result offset?

i want to make the cursor fast in any time whatever how many results returnedi didnt understand what xactly you meant by your first line but for this
>>i want to make the cursor fast in any time whatever how many results returned

there some optional parameters when you declare a cursor..for xample :
BOL has a good reference about it..look under 'DECLARE CURSOR'

Transact-SQL Extended Syntax
DECLARE cursor_name CURSOR
[ LOCAL | GLOBAL ]
[ FORWARD_ONLY | SCROLL ]
[ STATIC | KEYSET | DYNAMIC | FAST_FORWARD ]
[ READ_ONLY | SCROLL_LOCKS | OPTIMISTIC ]
[ TYPE_WARNING ]
FOR select_statement
[ FOR UPDATE [ OF column_name [ ,...n ] ] ]

you can use LOCAL, FORWARD_ONLY, READ_ONLY etc options to make it faster..

hth|||nono, i means the command like this:

sp_configure 'cursor threshold', xxx( a number, -1 = all synchronous, 0 = all asynchronous)

How many records in a table?

Hi! Stupid question as this also depends on hardware but is there a limit on
how many rows I can have in a single MSSQL 2000 table? Table consists of six
int columns and has three indexes. Is like 10 Million or 100 Million
considered to be 'normal' or unrealistic?

Thanks very much for your thoughts!

MartinMartin,

It's actually limited ONLY by hardware (disk space). I wouldn't say that 10
or 100 million are anywhere near "unrealistic". Maybe 1 trillion would be
more like it!

"Martin Feuersteiner" <theintrepidfox@.hotmail.com> wrote in message
news:cit9ft$m5b$1@.hercules.btinternet.com...
> Hi! Stupid question as this also depends on hardware but is there a limit
on
> how many rows I can have in a single MSSQL 2000 table? Table consists of
six
> int columns and has three indexes. Is like 10 Million or 100 Million
> considered to be 'normal' or unrealistic?
> Thanks very much for your thoughts!
> Martin|||Thanks!

"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:4152361a$0$2656$61fed72c@.news.rcn.com...
> Martin,
> It's actually limited ONLY by hardware (disk space). I wouldn't say that
> 10
> or 100 million are anywhere near "unrealistic". Maybe 1 trillion would be
> more like it!

How large does MSSQL scale?

I was at a bbq party last night, and one my close friends, a senior lead
developer with tons of MS certs from MCSD to MCSE and author of a Microsoft
book, told all of us that, "Microsoft SQL Server **does not** scale beyond 2
servers pointing to the same database".
This was a complete shocker to me. Is he correct?
We're building an app that needs to scale up as the demand increases. It
will probably be set up regionally with several SQL servers on the US East
and West coasts and China, and they all need to use the same database.
Is my friend right in saying that MSSQL cannot have more than 2 servers
pointing to the same database? He said Oracle on Linux would be a better fit
for our project.
Or is there some way to have these regional servers share the same database?
SQL Server 2000 installed on a Windows Server 2003 cluster can run on 4
nodes. Though, a database will only run on one server at a time (technically
its the instance that run only on one machine at a time).
See http://www.microsoft.com/usa/webcasts/ondemand/1751.asp for more
information
So 4 servers (8 servers with 64 bit support) can point to the same database,
but only 1 at point can use it. Hopefully that makes sense.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Scott" <nospam.scott@.scottkeen.com> wrote in message
news:uvhxcv%23dEHA.3916@.TK2MSFTNGP11.phx.gbl...
> I was at a bbq party last night, and one my close friends, a senior lead
> developer with tons of MS certs from MCSD to MCSE and author of a
Microsoft
> book, told all of us that, "Microsoft SQL Server **does not** scale beyond
2
> servers pointing to the same database".
> This was a complete shocker to me. Is he correct?
> We're building an app that needs to scale up as the demand increases. It
> will probably be set up regionally with several SQL servers on the US East
> and West coasts and China, and they all need to use the same database.
> Is my friend right in saying that MSSQL cannot have more than 2 servers
> pointing to the same database? He said Oracle on Linux would be a better
fit
> for our project.
> Or is there some way to have these regional servers share the same
database?
>
|||I am not sure exactly what your asking by this statement: "several SQL
servers on the US East
and West coasts and China, and they all need to use the same database".
SQL Server is a relational database server application. It is pretty much
an all inclusive app meaning that the database(s) are all owned by one SQL
server. You don't have SQL Server running on a server in Atlanta that owns
a database running on another Server in Chicago. With the exception of
using Distributed Partitioned Views a single SQL Server hosts one or more
databases on the same server as itself. Now don't take that to mean you can
not have other Servers (including SQL Server) connected to it. There are
plenty of SQL applications out there that have literally thousands of users
all over the world. I have personally worked on SQL Servers that handles
thousands of transactions per second, many Terabytes of data and thousands
of users. So you need to be a little clearer on exactly what you mean by
not scaling.
Andrew J. Kelly SQL MVP
"Scott" <nospam.scott@.scottkeen.com> wrote in message
news:uvhxcv%23dEHA.3916@.TK2MSFTNGP11.phx.gbl...
> I was at a bbq party last night, and one my close friends, a senior lead
> developer with tons of MS certs from MCSD to MCSE and author of a
Microsoft
> book, told all of us that, "Microsoft SQL Server **does not** scale beyond
2
> servers pointing to the same database".
> This was a complete shocker to me. Is he correct?
> We're building an app that needs to scale up as the demand increases. It
> will probably be set up regionally with several SQL servers on the US East
> and West coasts and China, and they all need to use the same database.
> Is my friend right in saying that MSSQL cannot have more than 2 servers
> pointing to the same database? He said Oracle on Linux would be a better
fit
> for our project.
> Or is there some way to have these regional servers share the same
database?
>
|||Thanks for the replies.
The concern was raised by the Linux guy in our dev group. I'm a developer,
not a DBA, however I'm responsible for making recommendations on what
technology we need to use for the app.
The Linux guy says, "Microsoft products don't scale well as demand
increases". Broad-sweeping comments like that are very dangerous for the
project, and I need to have my facts right when I make my technology
recommendations to management.
The concern is with what I've been told will be about tens of thousands of
users around the globe (mostly from China and the US coasts) hitting the
database at the same time with complex updates and selects. The concern is
that if SQL Server starts to bog down, then we should be able to throw on
more hardware to spread the load of the requests coming in and going out.
What can we do, so that as the demand on the database increases we'll be
able to throw hardware at the problem to distrubute the load?
Thanks,
Scott
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uImmR5$dEHA.1652@.TK2MSFTNGP09.phx.gbl...
> I am not sure exactly what your asking by this statement: "several SQL
> servers on the US East
> and West coasts and China, and they all need to use the same database".
> SQL Server is a relational database server application. It is pretty much
> an all inclusive app meaning that the database(s) are all owned by one SQL
> server. You don't have SQL Server running on a server in Atlanta that
owns
> a database running on another Server in Chicago. With the exception of
> using Distributed Partitioned Views a single SQL Server hosts one or more
> databases on the same server as itself. Now don't take that to mean you
can
> not have other Servers (including SQL Server) connected to it. There are
> plenty of SQL applications out there that have literally thousands of
users[vbcol=seagreen]
> all over the world. I have personally worked on SQL Servers that handles
> thousands of transactions per second, many Terabytes of data and thousands
> of users. So you need to be a little clearer on exactly what you mean by
> not scaling.
> --
> Andrew J. Kelly SQL MVP
>
> "Scott" <nospam.scott@.scottkeen.com> wrote in message
> news:uvhxcv%23dEHA.3916@.TK2MSFTNGP11.phx.gbl...
> Microsoft
beyond[vbcol=seagreen]
> 2
East
> fit
> database?
>
|||SQL Server scales much better up than out. By that I mean you don't add
more servers but more processors, memory etc. If you really think you will
be in a situation where you will have to support thousands of users you
should be looking at hardware in the Unisys ES7000, HP Superdome range. You
can even get them in 64 Bit and they will scale up to 32 and 64 processors
with as much ram as you need. There are already a lot of people at or
beyond that level with SQL Server and with the proper hardware and PLANNING
it should not be a problem. If you have people who lack vision and have
never done something of this scale you may want to seek outside advise to
ensure it is a success. If you bring in a 4 proc box now and tomorrow it
can't handle the load you might indeed have to replace the hardware
altogether...
Andrew J. Kelly SQL MVP
"Scott" <nospam.scott@.scottkeen.com> wrote in message
news:uQeqo9FeEHA.2384@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Thanks for the replies.
> The concern was raised by the Linux guy in our dev group. I'm a developer,
> not a DBA, however I'm responsible for making recommendations on what
> technology we need to use for the app.
> The Linux guy says, "Microsoft products don't scale well as demand
> increases". Broad-sweeping comments like that are very dangerous for the
> project, and I need to have my facts right when I make my technology
> recommendations to management.
> The concern is with what I've been told will be about tens of thousands of
> users around the globe (mostly from China and the US coasts) hitting the
> database at the same time with complex updates and selects. The concern is
> that if SQL Server starts to bog down, then we should be able to throw on
> more hardware to spread the load of the requests coming in and going out.
> What can we do, so that as the demand on the database increases we'll be
> able to throw hardware at the problem to distrubute the load?
> Thanks,
> Scott
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uImmR5$dEHA.1652@.TK2MSFTNGP09.phx.gbl...
much[vbcol=seagreen]
SQL[vbcol=seagreen]
> owns
more[vbcol=seagreen]
> can
are[vbcol=seagreen]
> users
handles[vbcol=seagreen]
thousands[vbcol=seagreen]
by[vbcol=seagreen]
lead[vbcol=seagreen]
> beyond
It[vbcol=seagreen]
> East
servers[vbcol=seagreen]
better
>

How I can register MSSQL Server 2000 by IP Address

How I can register MSSQL Server 2000 by IP Address-

I installed MSSQL Server 2000 sp3a, Enterprise edition on windows 2000 advanced server box with sp4. Its primarily give instance with name like servername/sqlindia, Where sqlindia is instance and servername is physical machine name.

I would like to registration of sqlserver instance by IP Address. How I can do it.

Thanking You

R.MallEnsure the client network utility is mentioned with ALIAS using IP Address.