Welcome to W3Courses
 Like Us on Facebook

Database

How to Create MySQL Database with Godaddy

Embed Code: 

How to Create MySQL Database if you have a hosting account with Godaddy.

Share

How to Create MySQL Database with HSphere

Embed Code: 

How to Create MySQL Database if you use hsphere for your hosting account.

Share

How to Check SQL Server Version and Service Pack (SP)

To find the service pack installed on your SQL Server, open the Query Analyzer or ISQL or OSQL. Connect to your server and execute the following command:

Share

Connection Pool or Database Connection Pooling in MS SQL Server

A connection pool is a cache of database connections maintained by the database so that the connections can be reused when the database receives future requests for data.

In today's demanding applications, creating new connections for each user request from scratch, maintaining them, and tearing down the open connection is costly. Drawing from the pool eliminates this overhead. Connection pooling increases the performance of Web applications by reusing active database connections instead of creating a new connection with every request.

Share

SQL Server Connection Pooling Myths

A connection pool is a cache of database connections maintained by the database so that the connections can be reused when the database receives future requests for data. Some of the myths concerning connection pooling and the truth behind those myths are given below:

Myth 1:  Changing the connection string, even slightly, will force a new connection.

Truth: Its False.

Share

What is the use (purpose) of master model msdb and tempdb databases in MS SQL Server?

Microsoft(r) SQL Server(tm) has four system databases:

Share

Windows Authentication vs. Mixed Mode Authentication in SQL Server

Windows Authentication in SQL Server is managed by domain accounts while Mixed Mode Authentication uses both Windows Authentication and SQL Server Authentication.

While installing SQL Server you might see an option similar to the one below

Share

How to Restore Master Database in MS SQL Server

Master is the most important database in SQL Server. The following procedure has been tested and it works however we do not provide any guarantees. Please use it at your own risk.

Following are the steps to restore the Master database in SQL Server 2000:

Share

Enable or Disable Full Text Indexing with sp_fulltext_database in SQL Server

sp_fulltext_database can be used to enable or disable full text indexing on current database. Only members of the db_owner fixed database role can execute sp_fulltext_database.

In order to enable full text indexing, please execute the following code in the Query Analyzer after replacing NorthWind with your database name:

Share

Start or Stop the Population of a Full-Text Catalog using sp_fulltext_catalog in SQL Server

sp_fulltext_catalog  creates and drops a full-text catalog, and starts and stops the indexing action for a catalog. Multiple full-text catalogs can be created per database.

Following is the example of executing the sp_fulltext_catalog which should be run in the Query Analyzer.

 

Share