Others

I have never written a blog for a long time, but I have never been on the homepage. Like most new users, after having passed the classic three-tier petshop stage, I began to think about the issues of layering and data persistence. Over the past year,

Today I studied how to obtain the delegate chain. I found that only the delegate of a specific event can be obtained through events, which is not fully effective for some custom or non-event-class delegates, the following are my findings: Public

This script permit executes the sp_updatestats in all databases at same time. First I create the Stored Procedure abve in an admin database, for sample I create one database with Admin name where I put all administration objects create for me. you

SQL statement optimization principles: 1. Use indexes to traverse tables faster The index created by default is a non-clustered index, but sometimes it is not optimal. In a non-clustered index, data is physically stored on the data page randomly.

Sqlservr "execution program is the program that runs at SQL server startup. You can use the "sqlservr" program to start SQL server from the command line. When starting in this way, all the startup information is displayed in the Command Prompt

Original article: Recommended actions for processing upt or suspect Databases   Overview Database suspension and corruption are rare, but they may occur mainly because of fatal hardware errors or operation errors, such as deleting log files.   More

  There is a common misunderstanding that we should put the highly selective field at the top. This is usually only for the index of a field, for the composite index, we often need to put the field for Equality calculation at the beginning to look

 During each full backup, the backup data is written to different files on three different drives to speed up the backup (assuming that the northwind database is installed in sqlserver 2005) BACKUP DATABASE northwind TO DISK='c:\northwindfull1.bak'

Rule 1: create a unit (one class, one unit) for each class) Keep this in mind: the private and protected parts of a class are hidden only for the classes and procedures in other units. therefore, if you want effective encapsulation, you should use a

Function After trigger Instead of trigger Applicability Table Tables and views Number of triggers contained in each table or view Each trigger operation (Update, delete, and insert) contains multiple triggers.

Best Method for arranging differential Database Backup For large databases, full database backup requires a large amount of disk space. To save time and disk space, you can schedule multiple differential backups after a full database backup. Each

Several dynamic management views and functions can be used to monitor full-text search activities on server instances. View information about the full-text directory in which the filling activity is being performed View the current activity

The database must be patched with SP2 1) Add the image IP address and server name to the host of the subject.2) Add the subject IP address and server name to the image host.Achieve interconnection, Ping host name and IP address Host IP image

After running, you will know what happened. This is a simple example. For example, symmetric key encryption is not involved in certificate decryption. You can view: About symmetric key encryption using certificate decryptionCreate master key

A friend's checksum calculates the index created by the column: In the database design, you need to mark the URL of the webpage with Link nvarchar (1000 ). During the insert operation, you need to determine whether the same URL address record is

Recently, I am working on an HTML parsing engine, which is particularly confusing when processing forms. Based on the experience of the past week, I would like to summarize the HTML form submission rules.   Type = button Never

If the parent class declares a static variable, will the Child class share the same address or copy another one after inheritance? I don't understand. Write the code to verify it ~ Code Public class father { Public static string test = "static

After a preliminary study, the entire graphic control consists of the following parts:1. Annotations -- a set of graphical annotations2. chartareas-chart area set3. Legends-legend set4. Series -- a sequence set of charts (that is, a set of chart

[Dllimport ("mwrf32.dll", entrypoint = "rf_init", setlasterror = true, charset = charset. ANSI, exactspelling = true, callingconvention = callingconvention. stdcall)] Public static extern int16 rf_init (int16 port, long baud ); // Obtain the reader

C # When calling an unmanaged dynamic library, you often need to detach the dynamic library in real time. This example shows how to load, obtain method delegation, and detach a dynamic library: [Dllimport ("kernel32.dll")]Public static extern int