Tutorials to .com

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

Microsoft SQL Server Tutorial Articles


461: Mysqldump parameters MySql database backup options
Mysqldump parameters MySql database backup options shell> mysqldump [OPTIONS] database [tables] If you do not give up any table, the entire database will be dumped. Through the implementation of mysqldump - help, you can get your version of my...

462: MySQL comes with analysis tools slowlog the mysqldumpslow
MySQL comes with the slow log analysis tools mysqldumpslow My.cnf file as long as configured: log-slow-queries = [slow_query_log_filename] Can record more than the default 10s the SQL statement execution time. If you want to modify the default s...

463: MySQL File System preview
MySQL File System preview http://no.spam.ee/ ~ tonu / mysqlfs.html -------------------------------- In fact, this is not the usual sense of the file system, he did not have disk space, but use the MySQL daemon to store data. Able to SQL table and...

464: MySQL Security Guide (3)
MySQL Security Guide (3) 2.4 users do not set GRANT WITH GRANT OPTION "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y&quo...

465: MySQL Security Guide (2)
MySQL Security Guide (2) 2.1.3 database and table permissions Out Case Sensitivity ...

466: MySQL Security Guide (1)
MySQL Security Guide (1) MySQL as a system administrator, you have the responsibility to safeguard your MySQL database system for data security and integrity. This paper mainly introduces how to build a MySQL security system, from the system both i...

467: Achieve in the regular operation of Oracle
Achieve in the regular operation of Oracle As we all know, the general operating system will provide regular implementation of the mandate, for example: Unix platforms provided to allow the implementation of the mandate system order from time to ti...

468: Detailed installation Oracle8.1.7forRH8
Oracle 8.1.7 for RH8 explain the installation process 1). Preparing documents # mkdir-p / data / ora # cd / data / ora Copy all the files to / data / ora, a total of 12 documents binutils-2.11.93.0.2-11.i386.rpm 1,925,419 bytes compat-egcs-6.2...

469: Oracle client installed on the SCO
Oracle client installed on the SCO ORACLE Client FOR SCO (5.0.6) Have been installed in the case of the compiler to install oracle client side. 1.oracle user's login group and group membership to dba 2. To oracle user login, modify. Cshrc (o...

470: Redhat9 installed in Oracle9
Redhat9 installed in Oracle9 Exchange of your district about the best there is a big G, the second best of your hard disk partition must have enough space. I posted below that of the Chinese translation: 1, to create users and groups: [roko @ mi...

471: BLOB fields Oracle database access
BLOB fields Oracle database access Firstly, the test data table drop table filelist; commit; CREATE TABLE SYSTEM.FILELIST ( "FILENAME" VARCHAR2 (50) NOT NULL, "FILESIZE" NUMBER (20) NULL, "FILEBODY" BLOB NULL, P...

472: Oracle constraint management script
Oracle constraint management script We look at the work of such a business needs the actual database, which many in the current application is very practical. A regional bank data, the current city-level data, with the computer network technology a...

473: Steps to start Oracle
Steps to start Oracle $ Lsnrctl service LSNRCTL for Intel SVR4 UNIX: Version 8.1.6.0.0 - Production on 02-APR-2001 11:14:08 (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IP...

474: Understanding of Oracle database system parameters
Understanding of Oracle database system parameters SQL> SELECT name, isspecified FROM v $ obsolete_parameter; DECODE (ksppoflg, 1, "Obsolete", 2, "Underscored") FROM x $ ksppo ORDER BY kspponm; FROM x $ ksppi x, x $ ksppc...

475: Oracle database to maintain index
Oracle database to maintain index This article discussed only the most common Oracle index, that is, B-tree index. This article relating to the database version is Oracle8i. In Oracle in, SYSTEM table is automatically created when the installation...

476: Analysis of Oracle database data objects
Analysis of Oracle database data objects Data objects in Oracle database is the most basic table and view, there are other constraints, sequences, functions, stored procedures, packages, triggers and so on. The operation of the database can be attr...

477: ORACLE logical backup file of SH
ORACLE logical backup file of SH rq = `date +"% m% d "` su - oracle-c "exp system / manager full = y inctype = complete file = / oracle / export / db_comp $ rq.dmp" SH cumulative backup file: exp_cumu.sh rq = `date +"% m...

478: On ROLLBACKSEGMENT
On ROLLBACK SEGMENT rollback segment is in a very special ORACLE data objects, which deal with matters rollback operation. In general, we need (the number of concurrent user connections ORACLE / 4) rollback segment, the general use of private type...

479: OLAP and Multidimensional Data Analysis
OLAP and Multidimensional Data Analysis A, OLAP concept products based on the practical application of OLAP and OLAP users demand, it is a more simple and clear to the OLAP definition, that is, the rapid information-sharing multi-dimensional analys...

480: Significance of the kernel parameters
Significance of the kernel parameters shmmin - the smallest of the shared memory segment. shmmni - shared memory the number of identifier. shmseg - a process that could be allocated the largest number of memory paragraphs. shmall - the largest n...


Page 24 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]