Tutorials to .com

Tutorials to .com » Database » Sqlserver » Microsoft SQL Server Tutorial

Microsoft SQL Server Tutorial Articles


481: How to increase the ORACLE connections
How to increase the ORACLE connections sessions = (1.1 * process +5) However, we increase the number of process, they often can not start a database. This is because we have missed a unix tune system parameters: it is / etc / system / in semmns, t...

482: Basic knowledge of Oracle
Basic knowledge of Oracle Each database at least one control file (recommendation 3, respectively, on a different disk) Each database at least one tablespace (SYSTEM tablespace) To establish the purpose of SYSTEM table space is the same as far as...

483: Automatic backup Oracle database
Automatic backup Oracle database We plan to allow the database 23 o'clock at night to do export export backup, 2 in the morning the backup file will be copied to the tape, in the early morning of 4 will copy the backup file to another UNIX mach...

484: Oracle startup parameters
Oracle startup parameters There are several ways to start: 1, startup nomount Read init.ora file, restart instance, that the SGA and background processes to start, which only need to activate init.ora file. This approach commonly used in the repa...

485: ORACLE characters shown in the issue of character sets
ORACLE characters shown in the issue of character sets 1, Analysis Users through the analysis of the situation and found that an improper character set is the impact of the ORACLE database shows that the key issues of Chinese characters. Well, how...

486: Oracle database backup and recovery
Oracle database backup and recovery A, Export / Import (Export / Import) Export data to use can be extracted from the database using Import may be extracted from the data sent back to Oracle database. 1. A simple data export (Export) and import d...

487: Installed on the Linux machines to run Oracle (under)
Installed on the Linux machines to run Oracle (under) PL / SQL function get_annual_salary (emp_number in number) return number; end stored_sample; / create or replace package body stored_sample as function get_annual_salary (emp_number in numb...

488: Installed on the Linux machines to run Oracle (on)
Installed on the Linux machines to run Oracle (on) Action Environment variable to increase LOG = / tmp / oracle-root.sh.log, this script will record the results Python and Oracle Python 1.5.1 (# 1, Sep 3 1998, 22:51:17) [GCC 2.7.2.3] on linux-i3...

489: Find out how fast Oracle database lock wait
Find out how fast Oracle database lock wait In a large database, in order to ensure consistency of data in the database to operate, the system will lock the data accordingly. from v $ session a, v $ lock b where a.lockwait = b.kaddr select a.use...

490: AS3.0 installed in Oracle10g
AS3.0 installed in Oracle 10g http://dev.csdn.net/article/32/32100.shtm http://dev.csdn.net/article/32/32103.shtm http://dev.csdn.net/article/32/article/32/32111.shtm http://dev.csdn.net/develop/article/26/26541.shtm http://download-uk.oracle.c...

491: Oracle8i Installation in Linux and Application
Oracle 8i in Linux Installation and Application Basic configuration Hardware environment In this paper, the basic configuration of the Oracle installation are: hard disk space 40GB, memory 256MB. Software Environment Need to be prepared prior t...

492: Oracle Export and Import backup to restore the source code automatically generated sql
Oracle Export and Import backup to restore the source code automatically generated sql EXP_BACK_DIR: Export of the ORACLE database directory DMP release documents SCRIPT_FILE: the code generated by the batch file path and file name LOG_FILE: Expo...

493: How to maintain the excellent performance of Oracle databases
How to maintain the excellent performance of Oracle databases First, partition Based on actual experience, in a large database, data of the vast majority of space was a small number of tables in the country. In order to simplify the management of ...

494: Oracle automatically with the completion of the physical Linux backup
Oracle automatically with the completion of the physical Linux backup Oracle Database offers several methods of data backup, but the most logical or the use of exp backup, and physical backup (including online backup and offline backup) process doe...

495: Oracle and SUNSolaris kernel parameters
Oracle and SUN Solaris kernel parameters Some prior knowledge shared memory: shared memory segment: A memory region, the process can be different to read. Oracle to use it to form the SGA. Oracle using the following three methods to create an SGA...

496: PB / Sybase database system, the transfer of development
PB / Sybase database system, the transfer of development Abstract: In view of the large-scale MIS systems often encountered in a database will be transferred to the raw data of the database server to deal with problems on the local disk Foxbase dat...

497: Sybase Database Backup Program
Sybase Database Backup Program Sybase database products since its inception in 1987, its client / server (client / server) mode, the basis of distributed processing architecture, a comprehensive security performance, high-speed and efficient operat...

498: From the IIS to the SQLServer database security
From IIS to SQL Server database security General Web site are based on the database, especially ASP, PHP, JSP to use this database to the Web site dynamic display. Many sites may pay more attention to the loopholes in the operating system, but the ...

499: Arbitrary field can be sort of paging stored procedure
SELECT statement in SQL can be a SELECT statement as the content source, and nested laws to deal with this, but there is a premise must be as a result set SELEC sources specified alias is an example of the following SQL statement, you be able to con...

500: Nested query
SELECT statement in a WHERE clause or HAVING clause of another SELECT statement nested query as nested queries, also known as subqueries. Sub-query is an extension of SQL statements, the statement form is as follows: SELECT <target expression 1 ...


Page 25 of 39
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]   [33]   [34]   [35]   [36]   [37]   [38]   [39]