xeon server specification

Tags: compare database table state Efault Enter DDE System log print subquerySQL Server Database specification First, naming norms Common object naming conventions, using Pascal's nomenclature (Pascal, the first letter of the word capitalization), the uniform use of English. 1. Table. English singular noun, as far as possible to write the full word name generally not more than 3 English words can express

Tags: output CTI BSS date IDT NiO tor Access CollectionCommon SQL Server Specification highlights Source: Jing Yi Links: www.cnblogs.com/liyunhua/p/4534442.html Common field type selection 1. Varchar/nvarchar data types are recommended for character types 2. Money data type is recommended for monetary value 3. Scientific counting recommended numeric data type 4. Self-growth logo rec

index of the table is the primary key column, the name of the primary key has already been mentioned before, and the index name is the same as the primary key name (pk_ table name) For nonclustered indexes on a table, it is recommended to use (ix0_ table name, ix1_ table name) ...., so go on, so also very clearly expressed the index, for many named articles mentioned in the need for detailed expression of specific columns, I personally feel no need, first clustered index often involves mult

the {Pgid of their child processes. When a child process calls the Exec series of functions, the parent process can no longer set its pgid. 2.4 Session 2.4.1 Definition: Some associated process groups will form a session \ Implementation: Non-leader processes can call this function to create new sessions. Implementation feature: The calling process becomes the leader of the session, at which point the process is the only member of the new conversation. Create a new

single sheet——— Scripting ————— –In scripting, it is forbidden to perform complex calculationsIn scripting, avoid using SELECT *: Reduce the number of queries and unnecessary returnsIn scripting, it is forbidden to perform calculations on indexed columnsUse fewer cursorsUse fewer triggersIn scripting, the parameter types and column types in the table need to be consistentscripting, avoid splicing SQL, using parametric processingIn scripting, minimize the number of join tablesIn scripting, limit