sql server audit specification

and horizontally split the table to reduce the table size (sp_spaceuse) 3. upgrade hardware 4. Create an index based on the query conditions, optimize the index, optimize the access mode, and limit the data volume of the result set. Note that the fill factor should be appropriate (preferably the default value 0 ). The index should be as small as possible. Use a column with a small number of bytes to create an index (refer to the index creation). Do not create a single index for fields with a li

Original: SQL Server triggerThis article is to learn to use trigger data summary, the content from the network, at the end of the article will give the corresponding link address.In SQL Server R2, both T-SQL triggers are supported and CLR triggers are created.Introduction to

event. The "event properties" dialog box shown in 4.50 is displayed. The event details are displayed here. In this example, the review succeeded. This item shows whether a hacker has successfully intruded into the system. Figure 4.50 event Properties dialog box (4) Events of different applications may be recorded in the event viewer.If you only want to view and SQLFor server-related event records, right-click Application and choose View> filter from

I/O.　　 2. vertically and horizontally split the table to reduce the table size (sp_spaceuse)　　 3. upgrade hardware　　 4. Create an index based on the query conditions, optimize the index, optimize the access mode, and limit the data volume of the result set. Note that the fill factor should be appropriate (preferably the default value 0 ). The index should be as small as possible. Use a column with a small number of bytes to create an index (refer to the index creation). Do not create a single i

impossible to design a system completely according to the standardization. Unless the system is very small, it is necessary to add redundancy in a planned manner after the standardization design. Redundancy can be a redundant database, a redundant table, or a redundant field. redundancy at different granularities can play different roles. Redundancy can be increased for programming convenience or for performance improvement. From a performance perspective, redundant databases can distribute

port number and whether the TCP/IP protocol is enabled.Procedure:1) Open "Enterprise Manager", open the console root directory> SQL Server group> Database2) Right-click the database and choose Properties"3) Select the "General" tab and click "network configuration". If no "TCP/IP protocol" is enabled, add it 4) Select "TCP/IP protocol" and click "properties" to check whether the port number is 1433.5) If t

Tags: style blog http io os ar using for strongThis article is to learn to use trigger data summary, the content from the network, at the end of the article will give the corresponding link address.In SQL Server R2, both T-SQL triggers are supported and CLR triggers are created.Introduction to a Trigger1) Trigger classification Login trigger: Is triggere

this case, the complete set of statements is fairly small. Now it is assumed that there are multiple statements in the procedure, and some of these procedures use other statements to invoke other procedures. Collecting all this extra data now becomes a very powerful load on the system. In the production machine must be used with caution. Now go back to the event selection panel and only the events that have been selected will be displayed. If you want to display all the events available for sel

4199 All KB patches take effect for the query analyzer behavior modification. This command is dangerous and may be called as performance degradation. For details, see: http://support.microsoft.com/kb/974006 Trace flag should not be enabled in the production environment Trace Flag 806 Check the logical consistency of pages during reading. The following information is displayed in the error log:11:29:04. 11 spid51 error: 823, severity: 24-day status: 211:29:04. 11 spid51 I/O error (

disperse the concurrency pressure of the large scale data, also can speed up the speed of special query, the redundant field can reduce the connection of database table effectively and improve the efficiency.3.Design of the primary keyThe primary key is necessary, and the primary key for SQL Server is a unique index, and in practice, we tend to choose the smallest key group to work as the primary key, so t