Tutorials to .com

Tutorials to .com » Database Tutorial

Database Tutorial Articles


1: A safe and stable database SQLSERVER
A safe and stable SQL SERVER Database 1, first of all you have to confirm your identification model: WIN NT authentication mode or mixed mode of it, which mixed-mode, including WIN NT authentication mode and differential mode SQL SERVER steps in th...

2: Experience
Experience A successful management system is determined by: [50% + 50% of business software] formed, while another 50% of the success of the software [25% of the database + 25% of the programs] of the composition, the database design good or bad is...

3: uard configuration StepbyStep
uard configure Step by Step link: http://www.eygle.com/ha/dataguard-step-by-step.htm 1. the primary node back up and generate the standby database control file to set the primary node to force Logging mode (for bi-directional switch, the proposed s...

4: uard configuration StepbyStep
uard configure Step by Step link: http://www.eygle.com/ha/dataguard-step-by-step.htm 1. the primary node back up and generate the standby database control file to set the primary node to force Logging mode (for bi-directional switch, the proposed s...

5: Oracle10g's SQL Regular Expression Support
Oracle 8 and Oracle 9i lack of flexibility in SQL Regular Expressions in Oracle 10 g finally been resolved. Oracle database is currently built-in line with the standard POSIX regular expressions. Four new functions are: REGEXP_LIKE, REGEXP_INSTR, R...

6: Oracle10g's SQL Regular Expression Support
Oracle 8 and Oracle 9i lack of flexibility in SQL Regular Expressions in Oracle 10 g finally been resolved. Oracle database is currently built-in line with the standard POSIX regular expressions. Four new functions are: REGEXP_LIKE, REGEXP_INSTR, R...

7: tybuffer
ty buffer In fact, everyone v $ bh to this view may have been getting short shrift. We look at this view, the main field Description: STATUS VARCHAR2 (1) Status of the buffer: FREE - not currently in use XCUR - exclusive SCUR - shared current ...

8: Oracle9i physical memory management
In previous versions of Oracle9i, you can only start when the control of Oracle database using UNIX memory. Oracle provides some INIT.ORA parameters to detect the system global area (system global area, SGA) the size of the RAM. Once started the dat...

9: Do not, upload ago, at the client to determine the size of image files
Do not, upload ago, at the client to determine the size of image files Was previously collected TIPS, recently used in the project, and it may be helpful. "! - Taken from the 51js -> <script> var img = null; function s () ( if (...

10: To calculate the time difference in the Oracle9i
Calculate the time difference is the Oracle DATA data type, a common problem. Oracle supports date calculations, you can create, such as "Date 1 - Date 2" This kind of expression to calculate the time difference between the two dates. Onc...

11: (Primary, intermediate, advanced)
(Primary, intermediate, advanced) Operational data: SQL Operational data: SQL n SQL-based n Intermediate SQL n Senior SQL ========================================= =============================== n SQL-based ¨ ¨ SQL Introduction ¨ ¨ using ...

12: (Primary, intermediate, advanced)
(Primary, intermediate, advanced) Operational data: SQL Operational data: SQL n SQL-based n Intermediate SQL n Senior SQL ========================================= =============================== n SQL-based ¨ ¨ SQL Introduction ¨ ¨ using ...

13: (Primary, intermediate, advanced)
(Primary, intermediate, advanced) Operational data: SQL Operational data: SQL n SQL-based n Intermediate SQL n Senior SQL ========================================= =============================== n SQL-based ¨ ¨ SQL Introduction ¨ ¨ using ...

14: (Primary, intermediate, advanced)
(Primary, intermediate, advanced) Operational data: SQL Operational data: SQL n SQL-based n Intermediate SQL n Senior SQL ========================================= =============================== n SQL-based ¨ ¨ SQL Introduction ¨ ¨ using ...

15: (Primary, intermediate, advanced)
(Primary, intermediate, advanced) Operational data: SQL Operational data: SQL n SQL-based n Intermediate SQL n Senior SQL ========================================= =============================== n SQL-based ¨ ¨ SQL Introduction ¨ ¨ using ...

16: Access non-Oracle files to create the external table
Oracle9i can directly obtain data from the operating system files, and let it look like the same as the database's internal tables. Oracle9i has expanded its interface with the operating system, so let any type of flat file to operate as if thi...

17: Access non-Oracle files to create the external table
Oracle9i can directly obtain data from the operating system files, and let it look like the same as the database's internal tables. Oracle9i has expanded its interface with the operating system, so let any type of flat file to operate as if thi...

18: End SQLSERVER database to the local directory
End SQL SERVER database to a local directory / * Database backup stored procedures * / / * Support for backup data from the server to the local machine * / - Author: yoncen CREATE PROCEDURE up_dbbackup ( @ backup_db_name VARCHAR (128), @ file...

19: Optimizing Oracle network configuration
Oracle database in a different geographic been widely used, so we must have professional staff know how to network connections, Oracle how the kind of impact database performance. Oracle provides TNS allows distributed communications in each databas...

20: How to obtain all the SQLServer server LAN
How to obtain the LAN to all SQL Server servers PAN id = ArticleContent1_ArticleContent1_lblContent> How to obtain the LAN to all SQL Server servers Literature reference sources: Delphi-depth exploration of I've always wanted in my applic...