mysql jar file(JDBC Driver for MySQL -Connector/J) should be in your classpath. if jar file is in your classpath and you are not able to connect the mysql...please post the error msg so that we can help you to connect the mysql

This is a generic question so I would give you a generic answer which is available widely in the world wide web.

Online transaction processing, or OLTP, refers to a class of systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing. The term is somewhat ambiguous; some understand a "transaction" in the context of computer or database transactions, while others (such as the Transaction Processing Performance Council) define it in terms of business or commercial transactions. OLTP has also been used to refer to processing in which the system responds immediately to user requests. An automatic teller machine (ATM) for a bank is an example of a commercial transaction processing application.

Regards,

Ashutosh.

http://sqlserverknowledge.wordpress.com

A table can have no indexes which is called a heap, a clustered index, a clustered and many non clustered indexes, only a non clustered index, or many non clustered indexes.

Regards,

Ashutosh.

http://sqlserverknowledge.wordpress.com

A non-clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a non-clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

A clustered index is a special type of index that reorders (sorts) the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.

Regards,

Ashutosh.

http://sqlserverknowledge.wordpress.com

By Default SQL Server runs on 1433 port.

Below are the steps to assign a TCP/IP port number to the SQL Server Database Engine
In SQL Server Configuration Manager, in the console pane, expand SQL Server 2005 Network Configuration, expand Protocols for , and then double-click TCP/IP.

In the TCP/IP Properties dialog box, on the IP Addresses tab, several IP addresses appear, in the format IP1, IP2, up to IPAll. One of these are for the IP address of the loopback adapter, 127.0.0.1. Additional IP addresses appear for each IP Address on the computer. Right-click each address, and then click Properties to identify the IP address that you wish to configure.

If the TCP Dynamic Ports dialog box contains 0, indicating the Database Engine is listening on dynamic ports, delete the 0.

In the IPn Properties area box, in the TCP Port box, type the port number you wish this IP address to listen on, and then click OK.

In the console pane, click SQL Server 2005 Services.

In the details pane, right-click SQL Server () and then click restart, to stop and restart SQL Server.

After you have configured SQL Server to listen on a specific port there are three ways to connect to a specific port with a client application:

Run the SQL Server Browser service on the server to connect to the Database Engine instance by name.

Create an alias on the client, specifying the port number.

Program the client to connect using a custom connection string.

Regards,

Ashutosh.

http://sqlserverknowledge.wordpress.com

Use the Database Mail feature available for SQL Server to send any kind of mail. This has to be enabled first to make use of it.

Regards,

Ashutosh

http://sqlserverknowledge.wordpress.com

Use the Database Mail feature available for SQL Server to send any kind of mail. This has to be enabled first to make use of it.

Regards,

Ashutosh

http://sqlserverknowledge.wordpress.com

step1:: First start the Windows registry editor.
step2:: In registry editor locate the following registry key

HKEY_LOCAL_MACHINESOFTWAREMicrosoft
Microsoft SQL Server
MSSQLServerSuperSocketNetLibTcp

In Management Studio (after connecting to the server) open "Management" and then open "SQL Server Logs". Open the "Current" log and scroll to the bottom of the log. Look for the text "Server is listening on .....####'
OR

Go to the registry entries as shown below:

Default instance

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\TCP

Named instance

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server(InstanceName)\MSSQLServer\SuperSocketNetLib\TCP

Regards,

Ashutosh.

http://sqlserverknowledge.wordpress.com

fetch only required result set from the large table by where clause then make join in upper level.

Please find the answer of this question in the question asked below:

http://www.javamad.com/read/index.php?home=720

Regards,

Ashutosh.

http://sqlserverknowledge.wordpress.com

The performance of a stored procedure/query can be measured by SET STATISTICS IO and SET STATISTICS TIME commands. For a detailed explanation as to how to read results and improve performance can be found in the below article:

http://sqlserverknowledge.wordpress.com/2011/02/20/using-set-statistics-io-and-set-statistics-time-%E2%80%93-how-to-read-results/

Regards,

Ashutosh.

http://sqlserverknowledge.wordpress.com

When there is a failure updating rows in a transaction, the transaction state becomes invalid and the transaction rolls back if there is a rollback statement. If there is no rollback statement then the lock on that row is still held.

if its not in a transaction and the updation fails, then it just does not do anything on the records and as its not in a transaction the locks are also released if the database is in auto commit state.

Regards,

Ashutosh

http://sqlserverknowledge.wordpress.com